I want to create a table which contains a foreign key that referes to another table. SSMC says it' s good when I parse the SQL comand
but I execute it the following error message appears
Msg 8135, Level 16, State 0, Line 2
Table level constraint does not specify column list, table 'JUDETE'.
Here is the code
USE Test;
CREATE TABLE STATES
(
[#S] INT NOT NULL,PRIMARY KEY,
NameState VARCHAR(32) NOT NULL,
Country INT NOT NULL,
CONSTRAINT FKCountry FOREIGN KEY (Country) REFERENCES COUNTRIES ([#C])
);