Index.SortInTempdb-Eigenschaft
Gets or sets the Boolean property value that specifies whether the index is sorted using the tempdb database for intermediate storage of data.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property SortInTempdb As Boolean
Get
Set
'Usage
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)
Eigenschaftswert
Typ: 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).
Hinweise
![]() |
---|
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. |
Beispiele
Erstellen, Ändern und Löschen von Indizes
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo-Namespace