Wouldn't you know it, I reinvented the wheel. :P
Joe. <g>
>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.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams