Foreign key references invalid table

sql

Solution

Please see in this SQLfiddle link, Link

CREATE TABLE NUMBER(
    ID INT PRIMARY KEY, 
    NUMBER VARCHAR(10) NOT NULL,
    NAME VARCHAR(36) NOT NULL REFERENCES USERS(NAME)
);

Problem

I have the following code: ``` create table test.dbo.Users ( Id int identity(1,1) primary key, Name varchar(36) not null ) create table test.dbo.Number ( Id int identity(1,1) primary key, Number varchar(10) not null, Name varchar(36) not null foreign key references Users.Name ) ``` The foreign key throws an error saying `Foreign key 'FK__Number__Name__1CF15040' references invalid table 'Users.Name'.`. What did I do wrong?

Original source