title: To use or not to use identity on a lookup table
body: <p>In SQL Server I have the following lookup table that holds degree levels:</p>
  
  <pre><code>create table dbo.DegreeLevel 
  ( 
      Id int identity not null
         constraint PK_DegreeLevel_Id primary key clustered (Id),
      Name nvarchar (80) not null
         constraint UQ_DegreeLevel_Name unique (Name)
  )
  </code></pre>
  
  <p>Should I use identity on the <code>ID</code>?</p>
  
  <p>When should I use identity or a simple int in a lookup table?</p>