Setting the identity property on a table when it is created is a simple task. The below snippet will create table called SampleTable with ID column which has an identity property.
Read http://www.sql-server-performance.com/2015/remove-identity-column-sql-server/
