In a table(say table1) I have a identity column(say Col1).I want to remove the identity property of the Col1 but int property will remain same.
How can I do it by Query Analyzer?
Subhasishcreate new table without identity col , copy the data , drop the old table and rename the new table to the old table name :mad:
Showing posts with label remain. Show all posts
Showing posts with label remain. Show all posts
Sunday, February 19, 2012
Subscribe to:
Posts (Atom)