Replicated-Eigenschaft
Ruft die Boolean-Eigenschaft ab, die angibt, ob die Tabelle repliziert wird.
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 Replicated As Boolean
Get
'Usage
Dim instance As Table
Dim value As Boolean
value = instance.Replicated
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool Replicated { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
virtual property bool Replicated {
bool get () sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
abstract Replicated : bool
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
override Replicated : bool
final function get Replicated () : boolean
Eigenschaftswert
Typ: System. . :: . .Boolean
Ein Boolean-Wert, der angibt, ob die Tabelle repliziert wird.
True gibt an, dass die Tabelle repliziert wird. Der Standardwert ist allerdings False.
Implementiert
Beispiele
The following code example displays the replication status for each AdventureWorks2008R2 table.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2008R2"];
foreach (Table tb in db.Tables)
{
if (tb.QuotedIdentifierStatus == true)
{
Console.WriteLine("Quoted identifiers in " + tb.Name + " may be used to allow characters that are normally prohibited by
SQL syntax rules.");
}
else
{
Console.WriteLine("Quoted identifiers in " + tb.Name + " can only be used to specify reserved SQL keywords.");
}
}
Powershell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
Foreach ($tb in $db.Tables)
{
if ($tb.QuotedIdentifierStatus -eq $TRUE)
{
Write-Host "Quoted identifiers in" $tb.Name "may be used to allow characters that are normally prohibted by SQL syntax
rules."
}
else
{
Write-Host "Quoted identifiers in" $tb.Name "can only be used to specify reserved SQL keywords."
}
}
Siehe auch