Propriedade do RDL Table.PartitionScheme

Artigo
04/26/2013

Gets or sets the name of the partition scheme that is configured for the table.

Essa API não é compatível com CLS.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
<SfcReferenceAttribute(GetType(PartitionScheme), "Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']",  _
    )> _
<CLSCompliantAttribute(False)> _
Public Property PartitionScheme As String 
    Get 
    Set
'Uso
Dim instance As Table 
Dim value As String 

value = instance.PartitionScheme

instance.PartitionScheme = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)]
[SfcReferenceAttribute(typeof(PartitionScheme), "Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']", 
    )]
[CLSCompliantAttribute(false)]
public string PartitionScheme { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone)]
[SfcReferenceAttribute(typeof(PartitionScheme), L"Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']", 
    )]
[CLSCompliantAttribute(false)]
public:
property String^ PartitionScheme {
    String^ get ();
    void set (String^ value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)>]
[<SfcReferenceAttribute(typeof(PartitionScheme), "Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
member PartitionScheme : string with get, set

function get PartitionScheme () : String 
function set PartitionScheme (value : String)

Valor da propriedade

Tipo: System.String
A String value that specifies the name of the partition scheme that is configured on the table.

Comentários

The property specifies the name of the partition scheme. The PartitionSchemeParameters property lists the file groups that the partition scheme uses to store the table data.

Exemplos

The following code example prints the name of the partition scheme, if one exists, for each AdventureWorks2012 table.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

foreach (Table tb in db.Tables) 
{
   if (tb.PartitionScheme != "")
   {
      Console.WriteLine("The " + tb.Name + " table uses the " + tb.PartitionScheme + " partition scheme.");
   }
   else
   {
      Console.WriteLine("The " + tb.Name + " table has no defined partition scheme.");
   }
}

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.PartitionScheme -ne "")
   {
      Write-Host "The" $tb.Name "table uses the" $tb.PartitionScheme "partition scheme."
   }
   else
   {
   Write-Host "The" $tb.Name "table has no defined partition scheme." 
   }
}