note 17044 deleted from function.mssql-select-db by sean
| From: | sean@php.net | Date: | Mon, 11 Jul 2005 16:23:37 +0000 |
| Subject: | note 17044 deleted from function.mssql-select-db by sean | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-91775@lists.php.net to get a copy of this message | ||
Note Submitter: david dot glass at brulines dot co dot uk
----
Rather then use the sysobjects table to list all the tables, it is better to use the following
query:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'