FakeSystemTable-Eigenschaft
Ruft den Boolean-Wert ab, der angibt, ob die Tabelle auf eine Systemtabelle verweist.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property FakeSystemTable As Boolean
Get
'Usage
Dim instance As Table
Dim value As Boolean
value = instance.FakeSystemTable
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool FakeSystemTable { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
virtual property bool FakeSystemTable {
bool get () sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
abstract FakeSystemTable : bool
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
override FakeSystemTable : bool
final function get FakeSystemTable () : boolean
Eigenschaftswert
Typ: System. . :: . .Boolean
Ein Boolean-Wert, der angibt, ob die Tabelle auf eine Systemtabelle verweist.
True gibt an, dass die Tabelle auf eine Systemtabelle verweist. Der Standardwert ist allerdings False.
Implementiert
Hinweise
The FakeSystemTable property specifies whether the Table object references a SQL Server system-defined table that is not implemented as a base, view, or table.
Beispiele
The following code example creates a new table, and displays the FakeSystemTable.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2008R2"];
Table tb = new Table(db, "Test Table");
Column col1 = new Column(tb, "Name", DataType.NChar(50));
Column col2 = new Column(tb, "ID", DataType.Int);
tb.Columns.Add(col1);
tb.Columns.Add(col2);
tb.Create();
if (tb.FakeSystemTable = true)
{
Console.WriteLine("The table is a system table);
}
Else
{
Console.WriteLine("The table is not a system table);
}
Powershell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
#Create the Table
$tb = new-object Microsoft.SqlServer.Management.Smo.Table($db, "Test Table")
$col1 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "Name", [Microsoft.SqlServer.Management.Smo.DataType]::NChar(50))
$col2 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "ID", [Microsoft.SqlServer.Management.Smo.DataType]::Int)
$tb.Columns.Add($col1)
$tb.Columns.Add($col2)
$tb.Create()
If ($tb.FakeSystemTable -eq $TRUE)
{
Write-Host "The table is a system table."
}
Else
{
Write-Host "The table is not a system table."
}
Siehe auch