Table/column definitions

[Helen267]

My apologies if this has been answered elsewhere, but the search function is not currently available.

I have a SQL Server database (which currently has an Access front-end). I was wondering if there is a way of reporting from within the SQL Query Analyser on all the table/column definitions, other than one by one (which would take a consider length of time)?

Any help would be greatly appreciated!

 

[vidru]

Look up the INFORMATION_SCHEMA views in BOL (Books Online - aka SQL Server Help).

Something like this might be what you're looking for:

[tt]SELECT * FROM INFORMATION_SCHEMA.COLUMNS
ORDER BY TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME[/tt]

-dave

 

[Helen267]

Thanks, that helps. I also discovered another way within the Enterprise Manager (which I hadn't used before) - these things aren't obvious when you're completely self-taught!

Helen