Minimum Requirements for Auto Increment, Unique, Not Null Primary Key in SQL Server
<p>I've seen many examples of CREATE TABLE statements being used to declare primary keys using NOT NULL, UNIQUE, IDENTITY, AUTO_INCREMENT etc., but I'm not sure what the minimum requirements are for setting up a table with an auto-incremental primary key column (of type int).</p>

<p>So I guess that's my question:</p>

<p>What are the minimum requirement for setting up a primary key which auto increments, is unique, and does not allow nulls?</p>