Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    6

    Unanswered: How to enable and disable the identity

    Hello there :-)

    Kindly help me find the answer on how to enable and disable the identity of a field on a table via SQL Script?

    Thanks :-)

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    SET IDENTITY_INSERT
    Allows explicit values to be inserted into the identity column of a table.

    Syntax:
    SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }

Posting Permissions

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