DROP CONSTRAINT Syntax

[tmunson99]

Does anyone know if there is a command where you can first check to see if a primary key exists or not before you add or drop it......similar to DROP TABLE IF EXISTS .....?

I currently use:

ALTER TABLE employees DROP CONSTRAINT [PK_Employees]

to drop the PK and

ALTER TABLE employees ADD CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[Empl_Id] ASC,
[Row Id] ASC
)

to add the primary key back after some other processing is done.

This works fine, but you can see if things get out of order and it tries to drop the constraint when it doesn't exist in the first place, I will get an error.

 

[dbomrrsm]

you can probably do a query on sysobject/syscolumns and sysconstraints system tables todo the check

download a copy of the make up of these tables and how they join:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]