467,198 Members | 1,269 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

check pending state

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
  • viewed: 3392
Share:
1 Reply
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by R. Clausen | last post: by
reply views Thread by GB | last post: by
2 posts views Thread by bwmiller16@yahoo.com | last post: by
reply views Thread by ?lafur Helgi R?gnvaldsson | last post: by
7 posts views Thread by satish mullapudi | last post: by
reply views Thread by Jo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.