Microsoft SDK for Java

AdoEnums.Schema Class Fields

The Schema class contains the fields shown in the following table.

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.

© 1999 Microsoft Corporation. All rights reserved. Terms of use.