Table.Replicated Property

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)

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether the table is replicated.If True, the table is replicated. Otherwise, False (default).

Implements

ITableOptions.Replicated

Examples

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

See Also

Reference

Table Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tables

CREATE TABLE (Transact-SQL)