Do not drop them and/or re-create them, though you could.

Lookup the "set integrity for <tablename> immediate unchecked" to
disable constraints, and "set integrity for <tablename> immediate
checked" to enable.

You can also do a "set integrity for <tablename> off" but that is a bit
different.

The "set integrity" command is documented in the Command Center Help
system.

Kevin Knaus

-----Original Message-----
From: Premnath
[mailto:db2udbdba-ezmlmshield-x35471969.[Email address protected]
Sent: Monday, May 26, 2003 12:11 AM
To: LazyDBA Discussion
Subject: Constraints

hi DBA's

How do we enable and disable the constraints of a table in DB2 8.2 ?

Regards



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page