KI_CREATE_PRIMARY_KEY_CONSTRAINT

Create a primary key on a table

CALL KI_CREATE_PRIMARY_KEY_CONSTRAINT handle TO status

status = 'ki_create_primary_key_constraint( handle )

KI_CREATE_PRIMARY_KEY_CONSTRAINT

This call creates a PRIMARY KEY constraint for a table based on its first index. The effect is the same as if _KDB_CONN_ATTR_CREATE_PRIMARY_KEYS was enabled when the index was created.

Requirements

• The table has been opened in X or U mode.
• The table has a unique index on path 1.
• The index is not a multi-language index.
• The index does not contain SUBSTR columns.
• _KDB_CONN_ATTR_CREATE_PRIMARY_KEYS is enabled.

Compatibility note:

This call is only supported on Oracle databases.

History

See Also: