If you want to create a table in the database connected through a ODBC DSN, you can run the CREATE TABLE SQL statement using the odbc_exec() function, as shown in the following sample script:

<?php

$con = odbc_connect('ggl_SQL_SERVER','sa','GlobalGuideLine');

# 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 = odbc_exec($con, $sql);

if (!$res) {

print("Table creation failed with error: ");

print(odbc_error($con).": ".odbc_errormsg($con)." ");

} else {

print("Table ggl_links created. ");

}

odbc_close($con);

?>