title: Can I use just one SQL query for auto increment and unique constraint?
body: <p>I have an SQL database. A table in the database contains a column which is ID. I want to write an SQL query that alters that table so the values for ID column are automatically incremented (ID is integer), starting from say 1. So, I already have a table with ID column, I just want to write a query to alter it so the values for ID column are automatically inserted. 
  Another column in the same table should have unique values (but is not primary key, primary key is ID), so I need to alter the table for that too. Can I cover this all with only one query? </p>