Once you have created a connection object, you can use the mssql_query() function to send a SQL statement to the SQL Server linked to the connection object for execution.

Here is a simple PHP script that creates a new schema and a new table:

<?php

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

mssql_select_db('GlobalGuideLineDatabase', $con);

# creating a new schema

$sql = 'CREATE SCHEMA ggl';

mssql_query($sql, $con);

# creating a new table

$sql = 'CREATE TABLE globalguideline (name VARCHAR(80))';

mssql_query($sql, $con);

mssql_close($con);

?>

If you run this script for the first time, it will execute those two statements correctly for you. But if you run it again, you will some warning messages:

Warning: mssql_query(): message: There is already an object

named 'ggl' in the database. (severity 16)

in C: estglobalguideline.php on line 7

Warning: mssql_query(): message: CREATE SCHEMA failed

due to previous errors. (severity 16)

in C: estglobalguideline.php on line 7

The messages are very clear and easy to understand.