table and column listing 1

[dbadmin]

Hi,

How could I get a listing of all tables and its columns from a database in SQL Server 2000/

dbadmin

 

[nigelrivett]

information_schema.tables
information_schema.columns

using ado and openschema

sysobjects
syscolumns

dmo



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[dbadmin]

Hi,

I figured out. I did it using sysobjects and syscolumns.

Thanks for the help.

dbadmin

 

[john76]

Thought I'd add this little bit to the thread:

using sysobjects and syscolumns will work fine, but if MS changes the format of the tables in the next version of SQL Server you may have a chore in porting your code.

INFORMATION_SCHEMA.Tables and INFORMATION_SCHEMA.Columns are views of the same data, but the format of the tables is supposed to remain the same regardless of what MS does to the system tables.

Therefore, it is generally advisable to use the INFORMATION_SCHEMA views instead of the system tables.

John