Hi Nick,

Thanks for your help. I just started playing with SQLDMO which 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
>
>SQLTABLES(yourhandle)
>or
>SQLEXEC(yourhandle,"EXEC sp_tables", "mySQLtables")
>
>and
>SQLEXEC(yourhandle,"EXEC sp_stored_procedures", "mySQLproc")