SQL Server Foreign Key Constraint References Invalid Table
<p>I have the following code:</p>

<pre><code>CREATE TABLE _CLIENT
(
   client_id int ,
   client_name varchar(50),
   type varchar(50),
   constraint _CLIENT_pk PRIMARY KEY(client_id),
   constraint _CLIENT_ch CHECK (client_id&gt;0),
   typee_id INT NOT NULL REFERENCES CLIENT_TYPE(typee_id)
)

CREATE TABLE CLIENT_TYPE
(
   typee_id int NOT NULL,
   name_type varchar(50),
   constraint CLIENT_TYPE_pk PRIMARY KEY(typee_id)
)
</code></pre>

<p>The foreign key throws an error saying: </p>

<pre><code>Foreign key 'FK__Number__Name__1CF15040' references invalid table 'Users.Name'
</code></pre>

<p>what's the wrong here?</p>