Thanks, I just came across the SQLDMO stuff and it seems to give me everything I need.

Aloha,

James

>>Hi All,
>>
>>Is there a way to get a list of table names from a SQL database? What about stored procedures?
>>
>>Thanks in advance for any help.
>>
>>Aloha,
>>
>James,
>
>There's the SQLTABLES() and SQLCOLUMNS() functions. There may be a stored system procedure to return them (sp_stored_procedures in the Master database, perhaps). However, this information can also be retrieved using SQLDMO if it's available.