>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")
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison