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:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment