Hi,
I had gone through the steps to remove JEMH configuration database tables but unable to drop 3 tables it gives error related to foriegn constraint , Please let me know how to remove these tables/dependencies. I am using MySQL.
Thanking You,
Regards
Onkar Ahire
Hi Onkar you can Drop the table by following command
Drop table table_name CASCADE
CONSTRAINTS;
It might help if you actually refer the error message given, for what tables?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply Tiago,
I am not able to drop 3 tables rest all droped where I stuck exactly , finally I tried as you said above, I tried to delete table in premutation way (1,2,3), (1,3,2), (2,1,3), (2,3,1), (3,1,2), and (3,2,1) but still same.
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply Tiago,
I am not able to drop 3 tables rest all droped where I stuck exactly , finally I tried as you said above, I tried to delete table in premutation way (1,2,3), (1,3,2), (2,1,3), (2,3,1), (3,1,2), and (3,2,1) but still same.
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Onkar, it seems to me just a matter of dropping the tables in the right order. When you get the foriegn constraint error, try to drop the table it refer to first.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply Tiago,
I am not able to drop 3 tables rest all droped where I stuck exactly , finally I tried as you said above, I tried to delete table in premutation way (1,2,3), (1,3,2), (2,1,3), (2,3,1), (3,1,2), and (3,2,1) but still same.
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.