check pending state

amitabh.mehra

If I drop some constraints on a table by 'alter table..' query, does
this table go into check pending state? If no, then what is the way to
put this table into check pending state other than using the SET
INTEGRITY statement?

Jul 6 '07 #1

Serge Rielau

am***********@gmail.com wrote:

If I drop some constraints on a table by 'alter table..' query, does
this table go into check pending state? If no, then what is the way to
put this table into check pending state other than using the SET
INTEGRITY statement?

DROPing a constraint will not place the table in check pending.
Other that SET INTEGRITY (what's bad about it?) LOAD will place a table
into check pending if there are constraints presents (check, or RI).

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Jul 6 '07 #2