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.