Propriété HasClusteredIndex
Obtient la valeur de la propriété Boolean qui spécifie si la table contient un index cluster.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasClusteredIndex As Boolean
Get
'Utilisation
Dim instance As Table
Dim value As Boolean
value = instance.HasClusteredIndex
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool HasClusteredIndex { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasClusteredIndex {
bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasClusteredIndex : bool
function get HasClusteredIndex () : boolean
Valeur de propriété
Type : System. . :: . .Boolean
Valeur Boolean qui spécifie si un index cluster est défini sur la table.
Si la valeur est True, un index cluster est défini sur la table. Dans le cas contraire, la valeur est False (valeur par défaut).
Notes
The B-tree leaf level of a clustered index is the rows of data.
Exemples
The following code example shows how to check each table in the AdventureWorks2008R2 database to see if it has a clustered index.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2008R2"];
Foreach (Table tb in db.Tables)
{
Console.WriteLine("The " + tb.Name + " table has a clustered index:" + tb.HasClusteredIndex.ToString());
}
Powershell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
Foreach ($tb in $db.Tables)
{
Write-Host "The" $tb.Name "table has a clustered index:" $tb.HasClusteredIndex
}
Voir aussi