title: How to add a foreign key referring to itself in SQL Server 2008?
body: <p>I have not seen any clear, concise examples of this anywhere online.</p>
  
  <p>With an existing table, how do I add a foreign key which references this table? For example:</p>
  
  <pre><code>CREATE TABLE dbo.Projects(
      ProjectsID INT IDENTITY(1,1) PRIMARY KEY,
      Name varchar(50)
  
  );
  </code></pre>
  
  <p>How would I write a command to add a foreign key which references the same table? Can I do this in a single SQL command?</p>