Error in creating a table

• Gheorghe Costin Flavian

  SSC Enthusiast

  Points: 194

  More actions

  June 18, 2006 at 5:23 am

  #171388

  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])

  );

• Ananda Kumar

  SSCommitted

  Points: 1865

  More actions

  June 19, 2006 at 2:07 am

  #644533

  Remove the comma which is just before Primary Key Keyword.

• Gheorghe Costin Flavian

  SSC Enthusiast

  Points: 194

  More actions

  June 19, 2006 at 5:33 am

  #644567

  Thanks, it works now. The error was because I forgot to declare as key #T.