Index.PadIndex Property
Gets or sets the Boolean property value that specifies whether space is left open on each page of the intermediate levels of the index.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Deklaracja
<SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)> _
Public Property PadIndex As Boolean
[SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)]
public bool PadIndex { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::ReadOnlyAfterCreation)]
public:
property bool PadIndex {
bool get ();
void set (bool value);
}
/** @property */
public boolean get_PadIndex ()
/** @property */
public void set_PadIndex (boolean value)
public function get PadIndex () : boolean
public function set PadIndex (value : boolean)
Property Value
A Boolean value that specifies whether there is available space on each page at the intermediary levels of the index. If True, the index is padded. Otherwise, False (default).
Remarks
This property cannot be modified by using the Alter method. To change the property, the index must be rebuilt or re-created.
Uwaga
For indexes based on the UserDefinedTableType object the value of PadIndex value is provided by sys.indexes and the value of PadIndex property is ignored.
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
See Also