Sisn't your foreign key
EmployeeID need to be INT or is it string or GUI ?Salso what's the error
Mi tried
INT but not working also the error is i cant add the FOREIGN KEY
BAre you sure there are no visible error messages?
If it can detect the errors it should also show the error message(s)
If it can detect the errors it should also show the error message(s)
Myou have to execute to see errors
Mit error is visible but i tried all the thing i know
Myes
Mi execute its saying
Incorrect syntax near 'AUTO_INCREMENT'
Pbecause thats not valid T-SQL
PID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY,PSQL isnt just SQL, there are many dialects
PMSSQL and SQL Express use T-SQL
Pthis is not the same as mysql dialect, or postgres
Mthanks now its working