Many tables require an ID column to assign a unique ID number for each row in the table. For example, if you have a table to hold forum member profiles, you need an ID number to identify each member. To allow SQL Server to automatically assign a new ID number for each new record, you can define the ID column with IDENTITY attribute as shown in the following sample script:

<?php

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

mssql_select_db('GlobalGuideLineDatabase', $con);

$sql = "CREATE TABLE ggl_users ("

. " id INTEGER IDENTITY NOT NULL"

. ", name VARCHAR(80) NOT NULL"

. ", email VARCHAR(80) NULL"

. ", time DATETIME NULL"

. ")";

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

if (!$res) {

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

print(" ".mssql_get_last_message()." ");

} else {

print("Table ggl_users created. ");

}

mssql_close($con);

?>