I've noticed that, if you have two .sql editing windows open in Eclipse, SQL tends to ignore the db that you have selected in each editing window and actually USE the last db that was selected in ANY editing window. I've accidentally killed good data this way.
Seems like it'd be correct to run the sql against the actual db in the drop-down list.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've noticed that, if you have two .sql editing windows open in Eclipse, SQL tends to ignore the db that you have selected in each editing window and actually USE the last db that was selected in ANY editing window. I've accidentally killed good data this way.
Seems like it'd be correct to run the sql against the actual db in the drop-down list.