Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Parent Property
Collapse the table of content
Expand the table of content

Table.Parent Property

Gets the Database object that is the parent of the Table object.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcObjectAttribute(SfcObjectRelationship.ParentObject, SfcObjectFlags.Design)]
public Database Parent { get; set; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.Database
A Database object value that is the parent of the Table object.

The following code example prints the name of the parent database for each AdventureWorks2012 table.

C#

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

foreach (Table tb in db.Tables) 
{
   Database pnt = tb.Parent;
   Console.WriteLine(pnt.Name);
}

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

Foreach ($tb in $db.Tables) 
{
   Write-Host $tb.Parent.Name
}

Community Additions

ADD
Show:
© 2015 Microsoft