Get all MSSQL tables using PHP

Source code viewer
$tables = array();
$link = mssql_connect('ip:port', 'username', 'password'); // Change database log in information.
mssql_select_db('database_name', $link); // Change database name.
 
// Get all mssql tables and put them in variable tables.
if ($link) {
  $result = mssql_query('select table_name from information_schema.tables order by table_name', $link);
  while ($row = mssql_fetch_row($result)) {
   $tables[] = $row[0];
}
else {
   echo 'Database connection failed while getting list of all tables in mssql.';
}
mssql_close($link);
 
// Print MSSQL table list.
print_r($tables);
Programming Language: PHP