
November 30th, 2004, 08:47 AM
|
 |
Contributing User
|
|
Join Date: Sep 2004
Location: Romania
Posts: 173
Time spent in forums: 1 Day 45 m 53 sec
Reputation Power: 4
|
|
Dropping table
I'm trying to drop an empty table that has a check constraint and I receive the following error:
"ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
MODIFY TRIGGER failed
action cancelled by trigger (1) to preserve data integrity
Cannot update trigger used by a CHECK Constraint"
What is the correct order of the "drops" and WHY does this happen ?? After all it is an empty table !!
|