title: IDENTITY NOT NULL at Table Creation
body: <p>Can anyone please tell me whether the instruction <code>IDENTITY NOT NULL</code> at a table creation is redundant or not? I mean, judging by the message</p>
  
  <p>DEFAULT or NULL are not allowed as explicit identity values.</p>
  
  <p>I would say that any column declared as <code>IDENTITY</code> is implicitly also declared as <code>NOT NULL</code>, but I would like to make sure. Can anyone please confirm?</p>
  
  <p>Thank you very much.</p>