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