Index.SortInTempdb Propiedad
Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property SortInTempdb As Boolean
Get
Set
'Uso
Dim instance As Index
Dim value As Boolean
value = instance.SortInTempdb
instance.SortInTempdb = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool SortInTempdb { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool SortInTempdb {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member SortInTempdb : bool with get, set
function get SortInTempdb () : boolean
function set SortInTempdb (value : boolean)
Valor de la propiedad
Tipo: System.Boolean
A Boolean value that specifies whether the index is sorted using the tempdb database for temporary storage. If True, the index is sorted in the tempdb database. Otherwise, False (default).
Comentarios
[!NOTA]
For indexes based on the UserDefinedTableType object the value of SortInTempdb property is always the default value and the value set by the user is ignored.
Ejemplos
Crear, modificar y eliminar índices
Vea también
Referencia
Espacio de nombres Microsoft.SqlServer.Management.Smo