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) );