score:5

Accepted answer

USER is a reserved keyword in SQL Server. Use [] to escape the name

CREATE TABLE [dbo].[STUDENT]
(
     STUDENT_ID  int not null Identity,
     SCHOOL_ID INT NOT NULL,
     CONSTRAINT PKEY PRIMARY KEY (STUDENT_ID),
     CONSTRAINT FKEY FOREIGN KEY (USER_ID)  REFERENCES [USER] (USER_ID)
)

More questions

More questions with similar tag