title: How to Auto-Increment Non-Primary Key? - SQL Server
body: <pre><code>CREATE TABLE SupplierQuote
  (
  supplierQuoteID int identity (3504,2) CONSTRAINT supquoteid_pk PRIMARY KEY,
  PONumber int identity (9553,20) NOT NULL
  .
  .
  .
  CONSTRAINT ponumber_uq UNIQUE(PONumber)
  );
  </code></pre>
  
  <p>The above ddl produces an error:</p>
  
  <blockquote>
    <p>Msg 2744, Level 16, State 2, Line 1
    Multiple identity columns specified
    for table 'SupplierQuote'. Only one
    identity column per table is allowed.</p>
  </blockquote>
  
  <p>How can i solve it? I want PONumber to be auto-incremented.</p>