Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Obtain table names in VFP database
Message
General information
Forum:
ASP.NET
Category:
Databases
Title:
Obtain table names in VFP database
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172879
Message ID:
01172879
Views:
67
I have a oledb connection to vfp database from net project. I need tables name list of vfp database and fields of any selected table of this database. How can I obtain this information by oledb connection.

I use this command if I connect to sqlserver.
"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES Where OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable')=1"


thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform