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.