Compartir a través de


Index.PartitionScheme Propiedad

Gets or sets the partition scheme associated with the index.

Esta API no es compatible con CLS. 

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<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 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)

Valor de la propiedad

Tipo: System.String
A String value that specifies the partition scheme associated with the index.

Comentarios

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.

Ejemplos

Crear, modificar y eliminar índices

Vea también

Referencia

Index Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

Índices

CREATE INDEX (Transact-SQL)