8. SQL Statements : MODIFY : With Clause Options for Modify : Nodependency_check
 
Share this page                  
Nodependency_check
A table cannot be modified if it destroys indexes needed for constraints. The operation can be forced, however, by using the NODEPENDENCY_CHECK option.
Important!  If you use this option, you must preserve or recreate the table structure necessary to enforce the constraints.