Results 1 to 2 of 2

Thread: permanently turn identity off using sql

  1. 09-03-2002, 07:40 AM #1
    Jill Guest

    permanently turn identity off using sql

    How, using SQL, do I turn off the identity property in the table? I need a script to run against a number of db to permanently remove the identity property from the tables without needing to use Enterprise Manager.

    Thank you,
    Jill
    Reply With Quote Reply With Quote
  2. 09-25-2002, 12:38 AM #2
    ClayG
    ClayG is offline Registered User
    Join Date
    Sep 2002
    Location
    Tasmania
    Posts
    8
    alter table [tblname]
    alter column [colname] integer
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules