5

I am trying to drop the database table created when my custom plugin is activated. I am using basically the same code, just a drop query. However, the table won't drop!

I have confirmed the following:

  • The WP Database User has privileges to drop tables (I confirmed by running sql query in workbench)

  • The query is being called and is correct (I used 'die($sql)' to output the query, then ran it in workbench)

    function my_plugin_remove_database() {
     global $wpdb;
     $table_name = $wpdb->prefix . "my_plugin_table";
     $sql = "DROP TABLE IF EXISTS $table_name;";
     //die($sql);
     require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
     dbDelta( $sql );
     delete_option("my_plugin_db_version");
}
register_deactivation_hook( __FILE__, 'my_plugin_remove_database' );
Kara
  • 6,115
  • 16
  • 50
  • 57
JimmyJammed
  • 9,598
  • 19
  • 79
  • 146

1 Answers1

12

Use $wpdb->query() instead of dbDelta()

function my_plugin_remove_database() {
     global $wpdb;
     $table_name = $wpdb->prefix . "my_plugin_table";
     $sql = "DROP TABLE IF EXISTS $table_name;";
     $wpdb->query($sql);
     delete_option("my_plugin_db_version");
}

register_deactivation_hook( __FILE__, 'my_plugin_remove_database' );

dbDelta() does not supported DROP TABLE query.

Faishal
  • 1,493
  • 1
  • 14
  • 23