title: How list out all tables in MSSQL?
body: <p>I'm using the code below to show the tables in my database. </p>
  
  <p>I get "Connected to database" but nothing else. Is my code correct? can I use another way to get the info I need? </p>
  
  <pre><code>&lt;?php 
  $link = mssql_connect('HOST', 'user', 'pass');
  
  if (!$link || !mssql_select_db('dbname', $link)) {
      die('Unable to connect or select database!');
  }else{
  echo"Connected to database";
  }
  
  
  $v = mssql_query("Select name from sysobjects where type like 'u'");
  $row = mssql_fetch_array($v);
  
  echo "&lt;br&gt;";  echo $row[0]; echo "&lt;br&gt;";
  
  
  mssql_free_result($v);
  ?&gt;
  </code></pre>