Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List of SQL stored procedures
Message
From
28/02/2006 15:25:03
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
List of SQL stored procedures
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01100089
Message ID:
01100089
Views:
50
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
Next
Reply
Map
View

Click here to load this message in the networking platform