How to DROP TABLE from database

  • MadScout

    (@madscout)


    14 years, 11 months ago

    I’m working on a plugin which creates a table on activation. How do I drop that table on deactivation? Here is my code so far, but all it does is create the table, not delete it on deactivation.

    ...other functions and things...
function POD_deactivate()
{
	global $wpdb;	//required global declaration of WP variable

	$table_name = $wpdb->prefix.POD_table_name;

	$sql = "DROP TABLE ". $table_name;

	$wpdb->query($sql);

}
register_activation_hook(__FILE__,'POD_install');
register_deactivation_hook(__('POD') , 'POD_deactivate' );
?>
Viewing 3 replies - 1 through 3 (of 3 total)
  • laqrhead

    (@laqrhead)

    14 years, 11 months ago

    I don’t know how to answer your question, but it would seem to me that you may want to leave the tables in place in case the the user decides to re-enable the plugin, the previous data is still in place. You’ve probably already thought of that though.

    NomikOS

    (@nomikos)

    14 years, 8 months ago

    probably the DB user that run your blog installation do not have drop privileges.

    ———————-

    you can view errors inside of a function:

    $sql = "DROP TABLE IF_EXISTS $table_name;";
$e = $wpdb->query($sql);
die(var_dump($e));
    mrthrust

    (@mrthrust)

    14 years, 2 months ago

    how about….

    function pluginUninstall() {

        global $wpdb;
        $table = $wpdb->prefix."your_table_name";

        //Delete any options thats stored also?
	//delete_option('wp_yourplugin_version');

	$wpdb->query("DROP TABLE IF EXISTS $table");
}

    than all you do is hook into wordpress when its being de-activated

    register_deactivation_hook( __FILE__, 'pluginUninstall' );

    that should clean up the database a little..

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to DROP TABLE from database’ is closed to new replies.