Home Forums SQL Server 7,2000 T-SQL switching off the identity on a column RE: switching off the identity on a column

  • June 17, 2003 at 6:29 am

    #461707

    Wouldn't you just redclare the column without IDENTITY in the definition?:

    

    ALTER TABLE MyTable

    ALTER COLUMN MyIdentityColumn INT NOT NULL