Table.IsSystemObject Table.IsSystemObject Table.IsSystemObject Property

Definition

Gets the Boolean property value that specifies whether the table is a system object.

public:
 property bool IsSystemObject { bool get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase)]
public bool IsSystemObject { get; }
Public ReadOnly Property IsSystemObject As Boolean
Property Value

A Boolean value that specifies whether the table is a system object.

If True, the table is a system object. Otherwise, False (default).

Implements

Examples

The following code example shows how to list system object tables in the AdventureWorks2012 database.

C#

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

foreach (Table tb in db.Tables)   
{  
   if (tb.IsSystemObject == True)  
   {  
      Console.WriteLine("The " + tb.Name + " table is a system object.");  
   }  
}  

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)   
{  
   If ($tb.IsSystemObject -eq $TRUE)  
   {  
      Write-Host "The" $tb.Name "table is a system object."  
   }  
}  

Applies to