Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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
}
Return to top
Show:
© 2016 Microsoft