ALTER TABLE DROP column failed because one or more objects accessed this column.

SQL Server in the deletion of constrained columns the basic processing method

1. First, you need to delete the key associated with the constraint
2. Delete field

Delete constraint statement:
ALTER TABLE
drop constraint  constraint name or key 

go Delete field statement '
ALTER TABLE  table
drop column field name ' You 

will be prompted for an error: because one or more objects access this column, ALTER TABLE DROP COLUMN pid failed.


when you create a constraint, you typically specify a constraint name by default if you do not display the specified constraint name.

created constraint general in Enterprise Manager: