News

To create a table ... primary or foreign key constraint, you need to use the ALTER TABLE statement and specify the name of the table and the constraint. To modify a constraint, you can use the ADD ...
ALTER TABLE customer ADD CONSTRAINT pk_customer PRIMARY KEY USING INDEX pk_customer; ALTER TABLE lineitem ADD CONSTRAINT pk_lineitem PRIMARY KEY USING INDEX pk_lineitem; ALTER TABLE nation ADD ...