I am newbie with MySQL. I have created a tablespace with a datafile, and I have tried to drop this tablespace without drop any object in that tablespace by using that SQL query:
DROP TABESPACE TBS_TEST;
ERROR 1529 (HY000): Failed to drop TABLESPACE
DROP TABESPACE TBS_TEST CASCADE ; ---also got ERROR
So, is it possible to
drop tablespace CASCADE in MySQL?