Alter Constraints

[ChrisQuick]

Is it possible to alter the definition of an existing constraint or do you have to drop it and then recreate it? [sig][/sig]

 

[dbachpb]

You must drop and recreate the constraint. [sig][/sig]

 

[ChrisQuick]

Thanks [sig][/sig]

 

[callsupratim]

What is the syntax of altering the constraints..including the dropping part.

 

[MikeLacey]

To drop a constraint.

[tt]ALTER TABLE dept DROP CONSTRAINT pk_dept;[/tt]

and to add it again.

[tt]ALTER TABLE dept ADD CONSTRAINT pk_dept PRIMARY KEY deptno;[/tt]

Mike
michael.j.lacey@ntlworld.com