drop table

Anon

hello, i need to drop a table called "users" from a database. Can anyone give me the code that will do this?

thanks in advance!

Anon

DROP TABLE [IF EXISTS] tbl_name [, tbl_name,...] [RESTRICT | CASCADE]

$sql = "DROP TABLE IF EXISTS users";

Anon

thanks for the help, but i'm still confused. I'm a real newbie, here's what i've got (the way i have interpreted this will probably make you laugh):

DROP TABLE [IF EXISTS] admin_stats [, admin_stats,...] [RESTRICT | CASCADE]

$sql = "DROP TABLE IF EXISTS users";

The name of the table is admin_stats.

oh and btw, that's actully what my file looks like 🙂

thanks.

Anon

no problem.

so if your tablename is admin_stats you would write the sql query as

$sql = "DROP TABLE IF EXISTS admin_stats";

Of course this will only execute granted that you are

a.) The administrator of the database
b.) You have permissions to create and drop tables in your database.

I've used MySQL and MSSQL Server and in both cases you have to either be a or b otherwise that statement will fail. The following PHP snippet (you can cut and paste this in your code--use either or but not both if you have either database) will assign the $sql query to drop the table admin_stats if it exists.

// Using MySQL
$hostname = "yourhostname here";
$username = "your user name here";
$password = "your password here";
$dbtablename = "dbtablename here";

$cnx = mysql_connect($hostname, $username, $password) or die ("Cannot connect to database");
mysql_select_db($dbtablename) or die ("Cannot use $dbtablename");
$sql = "DROP TABLE IF EXISTS admin_stats";
$result = mysql_query($sql, $cnx) or die ("Could not execute SQL statement");
if (!$result) { print "Error: Could not execute. Check permissions."; }

// Using MSSQL Server with ODBC driver
$dbname = "your odbc db here";
$username = "your user name here";
$password = "your password here";

$cnx = odbc_connect($dbname, $username, $password) or die ("Cannot connect to database");
$sql = "DROP TABLE IF EXISTS admin_stats";
$result = odbc_exec($cnx, $sql) or die ("Could not execute SQL statement");
if (!$result) { print "Error: Could not execute. Check permissions."; }

good luck