Results 1 to 2 of 2

Thread: Identity

  1. #1
    Join Date
    Oct 2003

    Unanswered: Identity

    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?

  2. #2
    Join Date
    Jul 2002
    create new table without identity col , copy the data , drop the old table and rename the new table to the old table name

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts