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?

Updated 6-Oct-10 23:07pm

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

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