in reply to Database Table Names
In SQL Server 2000 you can get a list of table names very simply -
select name from sysobjects where xtype = 'U'
If you know how to run a SQL query you will have no trouble using this code to get a list of tables.
For the sake of portability it might also be useful to note that ANSI SQL-92 provides a standard for querying table schema information:select TABLE_NAME from INFORMATION_SCHEMA.TABLES
See also this discussion started by gmax, particularly this node which has more relevant info.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Database Table Names
by tilly (Archbishop) on Nov 08, 2003 at 16:59 UTC |