Ошибка таблицы моста в скрипте SQL

Question

Я получаю следующую ошибку в Sql Fiddle:

Schema Creation Failed: Incorrect syntax near the keyword 'FOREIGN'.:   

Следующие мои CREATE TABLE скрипты:

CREATE TABLE Employees(
      UserName_ID varchar(255) NOT NULL,
      Password    varchar(255) NOT NULL,
      F_Name      varchar(255) NOT NULL,
      L_Name      varchar(255) NOT NULL,
      Email       varchar(255) NOT NULL,
      CONSTRAINT Employees_PK  PRIMARY KEY(UserName_ID));

    CREATE TABLE Training_Sessions (
        Session_ID          int IDENTITY (1,1) NOT NULL ,
        Session_Name        varchar(255)       NOT NULL,
        Session_Description varchar(255)       NOT NULL,
        Session_Date        varchar(255)       NOT NULL,
        Organizer           varchar(255)       NOT NULL,
        CONSTRAINT Training_Sessions_PK        PRIMARY KEY(Session_ID));

    CREATE TABLE Enrolled
    (
        UserName_ID varchar(255) NOT NULL,
        Session_ID  int          NOT NULL,
        CONSTRAINT PK_Enrolled   PRIMARY KEY
        (
            UserName_ID,
            Session_ID
        )
        FOREIGN KEY (UserName_ID) REFERENCES Employees(UserName_ID),
        FOREIGN KEY (Session_ID)  REFERENCES Training_Sessions(Session_ID);
    )

Я работаю над проектом, в котором БД еще не настроена на сервере, и пытаюсь избавиться от некоторых сценариев. Согласно http://megocode3.wordpress.com/2008/01/04/understanding-a-sql-junction-table/ мой синтаксис для SQL Server правильный

Answer 1

Пытаться:

CREATE TABLE Employees(
  UserName_ID varchar(255) NOT NULL,
  Password    varchar(255) NOT NULL,
  F_Name      varchar(255) NOT NULL,
  L_Name      varchar(255) NOT NULL,
  Email       varchar(255) NOT NULL,
  CONSTRAINT Employees_PK  PRIMARY KEY(UserName_ID));

CREATE TABLE Training_Sessions (
    Session_ID          int IDENTITY (1,1) NOT NULL ,
    Session_Name        varchar(255)       NOT NULL,
    Session_Description varchar(255)       NOT NULL,
    Session_Date        varchar(255)       NOT NULL,
    Organizer           varchar(255)       NOT NULL,
    CONSTRAINT Training_Sessions_PK        PRIMARY KEY(Session_ID));

CREATE TABLE Enrolled
(
    UserName_ID varchar(255) NOT NULL,
    Session_ID  int          NOT NULL,
    CONSTRAINT PK_Enrolled   PRIMARY KEY
    (
        UserName_ID,
        Session_ID
    ),
    CONSTRAINT user_fk FOREIGN KEY (UserName_ID) REFERENCES Employees(UserName_ID),
    CONSTRAINT sess_fk FOREIGN KEY (Session_ID)  REFERENCES Training_Sessions(Session_ID)
);