Clustered Property

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The Clustered property reports index clustering on Microsoft SQL Server primary keys.

Syntax

            object
            .Clustered [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write before the SQL Server primary key is created. Read-only if the Key object references an existing primary key.

Prototype (C/C++)

HRESULT GetClustered(LPBOOL pRetVal);
HRESULT SetClustered(BOOL NewValue);

Hinweise

The Clustered property has meaning if the Key object references a SQL Server table primary key. If the Key object references a foreign key, the value is always FALSE.

If TRUE, the referenced primary key either has, or will be created with, a clustered index supporting it.

If FALSE, the referenced primary key has, or will be created with, a nonclustered index. The default for new Key objects is FALSE.

Applies To:

Key Object