If you need to delete a table created before, you can run the DROP TABLE SQL statement using the mssql_query() function, as shown in the following sample script:

<?php

$con = mssql_connect('LOCALHOST','sa','GlobalGuideLine');

mssql_select_db('GlobalGuideLineDatabase', $con);

# dropping an existing table

$sql = "DROP TABLE ggl_links";

$res = mssql_query($sql,$con);

print("Table ggl_links dropped. ");

# creating a new table

$sql = "CREATE TABLE ggl_links ("

. " id INT NOT NULL"

. ", url VARCHAR(80) NOT NULL"

. ", notes VARCHAR(1024)"

. ", counts INT"

. ", time DATETIME"

. ")";

$res = mssql_query($sql,$con);

print("Table ggl_links created. ");

mssql_close($con);

?>

If you run this script, "ggl_links" will be dropped and created again:

Table ggl_links dropped.

Table ggl_links created.