Свойство PartitionScheme

Возвращает или задает имя схемы секционирования, настроенной для таблицы.

Этот API-интерфейс несовместим с CLS.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<CLSCompliantAttribute(False)> _
<SfcReferenceAttribute(GetType(PartitionScheme), "Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']",  _
    )> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property PartitionScheme As String
    Get
    Set
'Применение
Dim instance As Table
Dim value As String

value = instance.PartitionScheme

instance.PartitionScheme = value

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

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

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

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

Значение свойства

Тип: System. . :: . .String
Значение типа String, указывающее имя настроенной для таблицы схемы секционирования.

Замечания

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.

Примеры

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

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

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("AdventureWorks2008R2")

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