Constant |
Value |
Description |
PROVIDERSPECIFIC |
-1 |
Used if the provider defines its own nonstandard schema queries outside those listed below. |
ASSERTS |
0 |
Returns the assertions defined in the catalog that are owned by a given user. |
CATALOGS |
1 |
Returns the physical attributes associated with catalogs accessible from the DBMS. |
CHARACTERSETS |
2 |
Returns the character sets defined in the catalog that are accessible to a given user. |
COLLATIONS |
3 |
Returns the character collations defined in the catalog that are accessible to a given user. |
COLUMNS |
4 |
Returns the columns of tables (including views) defined in the catalog that are accessible to a given user. |
CHECKCONSTRAINTS |
5 |
Returns the check constraints defined in the catalog that are owned by a given user. |
CONSTRAINTCOLUMNUSAGE |
6 |
Returns the columns used by referential constraints, unique constraints, check constraints, and assertions, defined in the catalog and owned by a given user. |
CONSTRAINTTABLEUSAGE |
7 |
Returns the tables that are used by referential constraints, unique constraints, check constraints, and assertions defined in the catalog and owned by a given user. |
KEYCOLUMNUSAGE |
8 |
Returns the columns defined in the catalog that are constrained as keys by a given user. |
REFERENTIALCONSTRAINTS |
9 |
Returns the referential constraints defined in the catalog that are owned by a given user. |
TABLECONSTRAINTS |
10 |
Returns the table constraints defined in the catalog that are owned by a given user. |
COLUMNSDOMAINUSAGE |
11 |
Returns the columns defined in the catalog that are dependent on a domain defined in the catalog and owned by a given user. |
INDEXES |
12 |
Returns the indexes defined in the catalog that are owned by a given user. |
COLUMNPRIVILEGES |
13 |
Returns the privileges on columns of tables defined in the catalog that are available to, or granted by, a given user. |
TABLEPRIVILEGES |
14 |
Returns the privileges on tables defined in the catalog that are available to, or granted by, a given user. |
USAGEPRIVILEGES |
15 |
Returns the USAGE privileges on objects defined in the catalog that are available to, or granted by, a given user. |
PROCEDURES |
16 |
Returns the procedures defined in the catalog that are owned by a given user. |
SCHEMATA |
17 |
Returns the schemas (database objects) that are owned by a given user. |
SQLLANGUAGES |
18 |
Returns the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog. |
STATISTICS |
19 |
Returns the statistics defined in the catalog that are owned by a given user. |
TABLES |
20 |
Returns the tables (including views) defined in the catalog that are accessible to a given user. |
TRANSLATIONS |
21 |
Returns the character translations defined in the catalog that are accessible to a given user. |
PROVIDERTYPES |
22 |
Returns the (base) data types supported by the data provider. |
VIEWS |
23 |
Returns the views defined in the catalog that are accessible to a given user. |
VIEWCOLUMNUSAGE |
24 |
Returns the columns on which viewed tables, defined in the catalog and owned by a given user, are dependent. |
VIEWTABLEUSAGE |
25 |
Returns the tables on which viewed tables, defined in the catalog and owned by a given user, are dependent. |
PROCEDUREPARAMETERS |
26 |
Returns information about the parameters and return codes of procedures. |
FOREIGNKEYS |
27 |
Returns the foreign key columns defined in the catalog by a given user. |
PRIMARYKEYS |
28 |
Returns the primary key columns defined in the catalog by a given user. |
PROCEDURECOLUMNS |
29 |
Returns information about the columns of rowsets returned by procedures. |
DBINFOKEYWORDS |
30 |
Returns a list of provider-specific keywords. |
DBINFOLITERALS |
31 |
Returns a list of provider-specific literals used in text commands. |
CUBES |
32 |
Returns information about the available cubes in a schema (or the catalog, if the provider does not support schemas). |
DIMENSIONS |
33 |
Returns information about the dimensions in a given cube. It has one row for each dimension. |
HIERARCHIES |
34 |
Returns information about the hierarchies available in a dimension. |
LEVELS |
35 |
Returns information about the levels available in a dimension. |
MEASURES |
36 |
Returns information about the available measures. |
PROPERTIES |
37 |
Returns information about the available properties for each level of the dimension. |
MEMBERS |
38 |
Returns information about the available members. |
TRUSTEES |
39 |
Returns information about trustees. |