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.