It seems fairly hard to get a list of the tables from your database using MSSQL but this seems to do the trick. This is set to get only the User Tables and ignores the sytem tables.
function GetField($res,$field,$number) {
return stripSlashes(mssql_result($res,$number,"$field"));
}
mssql_connect("server","","") or die ("help me!");
mssql_select_db("") or die ("Noooo!");
$result = mssql_query ("sp_tables");
$fields = mssql_num_fields ($result);
$rows = mssql_num_rows ($result);
for ($f=0; $f<$rows; $f++) {
$CHKTYPE=GetField($result,"TABLE_TYPE",$f);
if($CHKTYPE=='TABLE'){
//$name = mssql_fetch_field($result, 2);
$field=GetField($result,"TABLE_NAME",$f)."<br>";
echo $field;
}
}