CREATE TABLE TABLE_NAME ( ID NUMBER CONSTRAINT ID_KEY PRIMARY KEY, NAME VARCHAR(50) CONSTRAINT NAME_NOT_NULL NOT NULL, CONSTRAINT NAME_FK FOREIGN KEY (NAME) REFERENCES OTHER_TABLE_NAME (NAME) );
ALTER TABLE EMPLOYEE ADD CONSTRAINT EMPLOYEE#ID_PRIMARY_KEY PRIMARY KEY (ID);