.png)
Table.Replicated Property
SQL Server 2012
Gets the Boolean property that specifies whether the table is replicated.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)] public bool Replicated { get; }
Property Value
Type: System.BooleanA Boolean value that specifies whether the table is replicated.If True, the table is replicated. Otherwise, False (default).
Implements
ITableOptions.ReplicatedThe following code example displays the replication status for each AdventureWorks2012 table.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];
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("AdventureWorks2012")
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."
}
}
