title: TSQL: NOCHECK Foreign Key inside CREATE TABLE
body: <p>I want to add a foreign key constraint inline with my CREATE TABLE statement. However, I also want to include the NOCHECK attribute. Can this be done in one pass inside the CREATE TABLE statement? I can't seem to find a good example.</p>
  
  <p>So, something like: </p>
  
  <pre><code>CREATE TABLE dbo.SampleTable (
     [ID] INT IDENTITY (1,1) NOT NULL,
     [ParentSampleTableID] INT NOT NULL,
     &lt;NOCHECK&gt; CONSTRAINT [FK_SampleTable_ParentSampleTable] FOREIGN KEY (ParentSampleTableID) REFERENCES dbo.ParentSampleTable ([ID])
  )
  </code></pre>
  
  <p>Any ideas?</p>