Class - Generation specific to Sybase

Primary key

The primary key (tagged value {primaryKey}) is directly inserted after use of instructions of the SQL89 norm: CONSTRAINT ... PRIMARY KEY.

For example:

ALTER TABLE class ADD

CONSTRAINT class_PK PRIMARY KEY (attribute1, attribute2)

Note: Only one primary key can be specified by the ALTER TABLE command.

Its deletion (drop) is carried out using the DROP CONSTRAINT clause of the ALTER TABLE command.

For example:

ALTER TABLE class

DROP CONSTRAINT class_PK

Note: Only one primary key can be deleted by the ALTER TABLE command.