|
|
|
|
|
|
|
|
|
version 6.5 (Modified)
The catalog commands enable you to retrieve information such as the list of tables stored in a data source's catalog, the list of column names in specified tables and the indexes associated with a table.
Using the catalog commands, you can:
• Retrieve a list of the installed ODBC drivers (OC GET DSN LIST)
• Obtain information regarding the schema of the data sources, such as tables, columns, and indexes (OC GET TABLE LIST, OC GET COLUMN LIST, OC GET SPECIAL COLUMN LIST, OC GET PRIMARY KEY LIST, OC GET FOREIGN KEY LIST)
• Access lists of server procedures and their column lists (OC GET PROCEDURE LIST, OC GET PROCEDURE COLUMN LIST)
• Get privilege information on tables and columns (OC GET TABLE PRIVILEGE LIST, OC GET COLUMN PRIVILEGE LIST, OC GET TABLE STAT)
• Retrieve information on a connection (OC GET TYPE INFO LIST, OC GET TYPE INFO).
|
|
|
|
|
|
|
|
|