Proprietà Index.PartitionScheme
Gets or sets the partition scheme associated with the index.
Questa API non è conforme a CLS.
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<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
'Utilizzo
Dim instance As Index
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)
Valore proprietà
Tipo: System.String
A String value that specifies the partition scheme associated with the index.
Osservazioni
This property cannot be modified by using the Alter method. To change the property, the index must be rebuilt or re-created.
[!NOTA]
For indexes based on the UserDefinedTableType object the value of PartitionScheme property is an empty string.
Esempi
Creazione, modifica e rimozione di indici
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo