sp_stored_procedures
>Is there a way in VFP to get a list of the names of all of the SQL stored procedures and the SQL views?
>
>
>
>I use "SELECT table_name FROM "+Alltrim(sql_src)+".INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE' ORDER BY 1" in SQLEXEC to get a lisy of my tables in SQL
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst