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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only