alter a table

I have a table with    col1 int identity
                       col2  nvarchar(500)

How can I programmatically alter the table from int identity to int, and also from int to int identity.
I do not want to use enterprise manager.
Thanks for your response.
nesifaAsked:
Who is Participating?
 
skhorshidConnect With a Mentor Commented:
pass the following SQL
--to create a table
create table ##test (id int identity)

--to remove identity from a column
alter table ##test alter column id int

i dont think you can make a column identity after the table is created
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.