Article is cool, now i know how to query the data dictionary. However i have created my own SQL statement that i use with MS Query, where i cannot define stored procedures but just SQL statements. Here are two simple statements that queries 1. all tables, 2. all tables with all columns.

1. tables

SELECT sysobjects.name 'Table-name'

FROM sysobjects sysobjects

WHERE (sysobjects.type='U') AND (sysobjects.status>1)

ORDER BY sysobjects.name

2. tables with columns

SELECT sysobjects.name 'Table-name', syscolumns.name 'Column-name', syscolumns.length, syscolumns.xprec, syscolumns.xscale, syscolumns.colid, syscolumns.bitpos, syscolumns.isnullable

FROM syscolumns syscolumns, sysobjects sysobjects

WHERE (sysobjects.type='U') AND (sysobjects.id=syscolumns.id)

ORDER BY sysobjects.name, syscolumns.colid

cheers, Peter