7 Replies
isn't your foreign key
EmployeeID need to be INT or is it string or GUI ?
also what's the errori tried
INT but not working also the error is i cant add the FOREIGN KEYAre you sure there are no visible error messages?
If it can detect the errors it should also show the error message(s)
you have to execute to see errors
it error is visible but i tried all the thing i know
yes
i execute its saying
Incorrect syntax near 'AUTO_INCREMENT'because thats not valid T-SQL
ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
SQL isnt just SQL, there are many dialects
MSSQL and SQL Express use T-SQL
this is not the same as mysql dialect, or postgresthanks now its working