Nope, I missed these as well. I created a pretty useful stored procedure though. read [Re-designed the wheel.] <g>

>Are you aware of these views:
>
>

SELECT *
>FROM [INFORMATION_SCHEMA].[TABLES]
>
>SELECT *
>FROM [INFORMATION_SCHEMA].[COLUMNS]

>
>>I need a stored proc to enumerate tables and then one to enumerate fields. This is straight from the the boss. I know how to use SQLDMO to get this but I have no experiance with stored procs. :( When it rains it pours.
>>
>>Joe.