SQL-DMO
Type Property (Key)
The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.
Applies To
Key Object |
Syntax
object.Type [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer that specifies key constraint attributes as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write when using the Key object to define a PRIMARY KEY or FOREIGN KEY constraint. Read-only when the Key object references an existing constraint.
Prototype (C/C++)
HRESULT GetType(SQLDMO_KEY_TYPE* pRetVal)
HRESULT SetType(SQLDMO_KEY_TYPE NewValue)
Settings
Constant | Value | Description |
---|---|---|
SQLDMOKey_Foreign | 3 | Key references, or will be used to create, a SQL Server FOREIGN KEY constraint. |
SQLDMOKey_Primary | 1 | Key references, or will be used to create, a SQL Server PRIMARY KEY constraint. |
SQLDMOKey_Unique | 2 | Key references a SQL Server UNIQUE constraint on a column not allowing NULL. |
SQLDMOKey_Unknown | 0 | Bad or invalid value. |