note 17044 added to function.mssql-select-db
| From: | david dot glass at brulines dot co dot uk | Date: | Fri, 23 Nov 2001 11:36:44 +0000 |
| Subject: | note 17044 added to function.mssql-select-db | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-21196@lists.php.net to get a copy of this message | ||
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'
--
http://www.php.net/manual/en/function.mssql-select-db.php
http://master.php.net/manage/user-notes.php?action=edit+17044
http://master.php.net/manage/user-notes.php?action=delete+17044
http://master.php.net/manage/user-notes.php?action=reject+17044