CREATE TABLE STUDENT_UNITCODE

( StudentId VARCHAR(7) NOT NULL,

UnitCode VARCHAR(7) NOT NULL,

UnitName VARCHAR(100),

PRIMARY KEY (StudentId,UnitCode) );

INSERT INTO STUDENT_UNITCODE

VALUES ('0023765','UG45783','Advance Database'),

('0023765','UG45832','Network Systems'),

('0023765','UG45734','Multi-User Operating System'),

('0035643','UG45832','Network Systems'),

('0035643','UG45951','Project'),

('0061234','UG45783','Advance Database');

CREATE TABLE UNIT (

UnitCode VARCHAR(10) PRIMARY KEY,

UnitName VARCHAR(50) NOT NULL );

INSERT INTO UNIT (UnitCode, UnitName)

SELECT DISTINCT UnitCode, UnitName

FROM STUDENT_UNITCODE;

FOREIGN KEY REFERENCES Unit(UnitCode);

ALTER TABLE STUDENT_UNITCODE DROP column UnitName;

My Question: FOREIGN KEY has syntax error, I need to check the correct syntax.