>Thanks for the reply and tip Jon. I am starting to remember things now, too bad it is time to go home.

Einar,

I was looking over some old T-SQL that I wrote and found a couple of other useful items. There are 2 built-in views that return this information based on the current database: INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS.

Laterness,
Jon