Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement to get table names in .dbc via ODBC
Message
From
11/12/1998 08:42:29
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00165543
Message ID:
00166504
Views:
23
>You would use the VFP SQLExec() function to send the SQL command. You would need to research the backend to determine what table(s) this information is stored in. In Oracle, there is an ALL_TABLES table where you can select table names based on criteria contained in the columns of that table. There is an ALL_OBJECTS table, all_views, ALL_SYNONYMS, ALL_TAB_COLUMNS [which is the one you would probably want in Oracle], etc. In the ALL_TAB_COLUMNS table, you have the columns of all the tables, views and clusters accessible to the user. You have the following columns in that table [Oracle 7.x]:
>
>OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, COLUMN_ID, DEFAULT_LENGTH, DATA_DEFAULT, NUM_DISTINCT, LOW_VALUE, HIGH_VALUE.

SQL Server 7.0 has added the same functionality through a set of views that begin with INFORMATION_SCHEMA.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform