t-sql code for altering/creatign indexes

t-sql alter table create index syntax example

Search for: t-sql alter table create index syntax example

Here is the msdn reference

t-sql auto sequence column create define

Search for: t-sql auto sequence column create define

an interesting link from sybase talking about identity columns

t-sql alter table to make a column an identity column

Search for: t-sql alter table to make a column an identity column

Ok this may not be as simple. Read this discussion on stackoverflow

For simple tables you can use sql manager to do the work for you. See this link