Click here to Skip to main content
15,877,103 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
I have a table named tbsta with the columns:

staid int (primary key)
stanam varchar(50)

I want to alter it and set is identity of staid to true. How do I do that?

Thanks
Posted
Updated 6-Oct-10 23:07pm
v2

Easiest way would be through SQL Management Studio.
Via programming you could send an ALTER TABLE SQL command.
 
Share this answer
 
v2
This thread[^] will help you.
 
Share this answer
 
Comments
Rohit from Delhi 8-Oct-10 1:50am    
thanx

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900