By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,850 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,850 IT Pros & Developers. It's quick & easy.

check pending state

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.