SQL Server Performance

error while drop constrin

Discussion in 'General DBA Questions' started by sramesh, Mar 1, 2006.

  1. sramesh New Member

    ALTER TABLE [dbo].[tripsheet]
    drop CONSTRAINT [PK_tripsheet]

    Server: Msg 7613, Level 16, State 1, Line 1
    Cannot drop index 'PK_tripsheet' because it enforces the full-text key for table 'tripsheet'.
    Server: Msg 3727, Level 16, State 1, Line 1
    Could not drop constraint. See previous errors.


    please help
  2. dineshasanka Moderator

  3. Adriaan New Member

    You'll have to drop the full-text index before you can drop PK_tripsheet.

    Are you sure you know what you're doing? You should only be dropping a primary key to change the definition, which is rather a big step to undertake.

    Just remember to re-create the dropped dependent objects after you've re-created the primary key.

Share This Page