>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.
George
Ubi caritas et amor, deus ibi est