note 58343 deleted from ref.mssql by danbrown
| From: | danbrown@php.net | Date: | Mon, 18 May 2009 02:11:07 +0000 |
| Subject: | note 58343 deleted from ref.mssql by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-155630@lists.php.net to get a copy of this message | ||
Note Submitter: info at pkcom do t co dot uk
----
if you are looking for the equivalent of mysql_list_tables for mssql, try this:
######## Listing table names
$query=mssql_query ( "select * from SYSOBJECTS where TYPE='U' order by NAME" ,
[connection resource]);
while ($row=mssql_fetch_row ( $query )){
echo "$row[0]<br>";
}
#########################