I have a table called Rating. It was linked to another Table called Movie by a foreign key, which I deleted. I used this query: "drop table movie_site.rating;". It gave me this error: Operation 'DROP CONSTRAINT cannot be performed on object ##### because CONSTRAINT 'RATING_ID' is dependent on that object. This is in myEclipse. Thanks.
Asked
Active
Viewed 759 times
0
-
You dropped the foreign key constraint or the other table? What commands have you issued? – BillRobertson42 Jun 26 '12 at 19:12
-
I dropped the foreign keys and that is all. If you can share how to drop the schema it is in, that would work as well. – user1281598 Jun 27 '12 at 12:51
-
I this a question about MySQL, or about Derby? You tagged it with both. – Bryan Pendleton Jul 01 '12 at 15:20
-
I have already fixed the issue, but it would appear not all of MySQL is recognized by Derby, at least not in the version I am using. – user1281598 Jul 02 '12 at 12:34