MySQL/MariaDB Drop Table if Created

Question

So I want to create a trigger or some other kind of method for dropping an entire table if it is created. I have the following SQL query but as of this moment I'm stuck.

CREATE OR REPLACE
    TRIGGER `kill_migrations` AFTER CREATE ON SCHEMA
BEGIN
    IF SYS.DICTIONARY_OBJ_TYPE = 'TABLE' THEN
        DROP TABLE IF EXISTS django_migrations
END;

How do I drop a table if it is created? The current SQL query provided has a syntax error around "Drop Table".

Rick James · Accepted Answer · 2016-04-10 06:22:22Z

1

The MySQL manual and the MariaDB manual clearly limit trigger_event_ to INSERT | UPDATE | DELETE. That is, CREATE is not an option. Note how the error 1064 ... syntax to use near 'CREATE ON ... points exactly there.

answered Apr 10, 2016 at 6:22

Rick James

144k15 gold badges144 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL/MariaDB Drop Table if Created

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related