Partager via

  • Article

Propriété FakeSystemTable

Obtient la valeur Boolean qui spécifie si la table référence une table système.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property FakeSystemTable As Boolean
    Get
'Utilisation
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

Valeur de propriété

Type : System. . :: . .Boolean
Valeur Boolean qui spécifie si la table référence une table système.
Si la valeur est True, la table référence une table système. Dans le cas contraire, la valeur est False (valeur par défaut).

Implémente

ITableOptions. . :: . .FakeSystemTable

Notes

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.

Exemples

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."
}