General information
Title:
Obtain table names in VFP database
Environment versions
Network:
Windows 2003 Server
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
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