Key Properties

Key Object Properties Methods Collections

Property Description

Application
    Application
    Write: No
The Application object.
Clustered
    Boolean
    Write: Before Add
Determines if the unique index associated with this Key is a clustered index. If True, this Key has a unique clustered index. If False, this Key has a unique nonclustered index. The default is False.
FillFactor
    Long
    Write: Before Add
The percentage of each page that SQL Server will fill with index data when creating a unique index for a new Key. Valid values are 0 through 100.
Name
    Identifier
    Write: Yes
The name of the Key. Optional on Keys.Add; SQL-DMO will automatically generate one if blank.
Parent
    Table
    Write: No
The Table object.
ReferencedKey
    Identifier
    Write: No
The key of the ReferencedTable which this foreign key references, if this is a foreign key.
ReferencedTable
    Identifier
    Write: Yes
The table that includes columns referenced by the KeyColumns of this Key. Data values in the KeyColumns must exist in the ReferencedColumns of this table.
Type
    SQLOLE_KEY_TYPE
    Write: Yes
The Key type.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.