Incorrect syntax for definition of the 'TABLE' constraint

Question

CREATE TABLE zombie_neutralization (
certificateID INT NOT NULL IDENTITY,
date_certificate DATE NOT NULL DEFAULT getDate(),
renewal_date DATE NOT NULL DEFAULT getDate(),
training_hour INT NOT NULL,
CONSTRAINT PK_certi PRIMARY KEY (certificateID),
References HR.Employees(empid),
CONSTRAINT FK_employees FOREIGN KEY (empid)

);

I tried to remove the comma that is above references

Answer 1

References is on the wrong line:

CREATE TABLE zombie_neutralization (  
certificateID INT NOT NULL IDENTITY,  
date_certificate DATE NOT NULL DEFAULT getDate(),  
renewal_date DATE NOT NULL DEFAULT getDate(),  
training_hour INT NOT NULL,  
CONSTRAINT PK_certi PRIMARY KEY (certificateID),  
CONSTRAINT FK_employees FOREIGN KEY (empid) References HR.Employees(empid)  
);  

See: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver15#foreign-key-constraints