sp_tables will return all of your tables and sp_columns will reutrn information about the column of a table. The SQL Server Books Online (BOL) contains a good explaination of both.

-Mike

>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.