Purpose
All the values of the Schema Enum:
The type of action to be performed when SetPermissions is called.
Prototype
FUNCTION AdoSchemaEnum ( ) AS ARRAY
Return
ARRAY Every row in this array has 2 values:
• The numeric value of the Enum value
• A text representation of this value
This array can be used to validate values, and to print a meaningful description of the values during debugging You can pass this array to the AdoEnum2Str() function to convert the value of an Enum to a string
Description
List of possible values
| adSchemaProviderSpecific | -1 Used if the provider defines its own nonstandard schema queries outside those listed below. <Provider specific> |
| adSchemaAsserts | 0 Returns the assertions defined in the catalog |
| adSchemaCatalogs | 1 Returns the physical attributes associated with catalogs accessible from the DBMS. |
| adSchemaCharacterSets | 2 Returns the character sets defined in the catalog |
| adSchemaCollations | 3 Returns the character collations defined in the catalog |
| adSchemaColumns | 4 Returns the columns of tables (including views) defined in the catalog |
| adSchemaCheckConstraints | 5 Returns the check constraints defined in the catalog |
| adSchemaConstraintColumnUsage 6 | Returns the columns used by referential constraints, unique constraints, check constraints, and assertions, defined in the catalog |
| adSchemaConstraintTableUsage | 7 Returns the tables that are used by referential constraints, unique constraints, check constraints, and assertions defined in the catalog |
| adSchemaKeyColumnUsage | 8 Returns the columns defined in the catalog that are constrained as keys |
| adSchemaReferentialConstraints | 9 Returns the referential constraints defined in the catalog that are owned |
| adSchemaTableConstraints | 10 Returns the table constraints defined in the catalog |
| adSchemaColumnsDomainUsage 11 | Returns the columns defined in the catalog that are dependent on a domain defined in the catalog |
| adSchemaIndexes | 12 Returns the indexes defined in the catalog |
| adSchemaColumnPrivileges | 13 Returns the privileges on columns of tables defined in the catalog |
| adSchemaTablePrivileges | 14 Returns the privileges on tables defined in the catalog |
| adSchemaUsagePrivileges | 15 Returns the USAGE privileges on objects defined in the catalog |
| adSchemaProcedures | 16 Returns the procedures defined in the catalog |
| adSchemaSchemata | 17 Returns the schemas (database objects) |
| adSchemaSQLLanguages | 18 Returns the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog. |
| adSchemaStatistics | 19 Returns the statistics defined in the catalog |
| adSchemaTables | 20 Returns the tables (including views) defined in the catalog |
| adSchemaTranslations | 21 Returns the character translations defined in the catalog |
| adSchemaProviderTypes | 22 Returns the (base) data types supported by the data provider. |
| adSchemaViews | 23 Returns the views defined in the catalog |
| adSchemaViewColumnUsage | 24 Returns the columns on which viewed tables, defined in the catalog |
| adSchemaViewTableUsage | 25 Returns the tables on which viewed tables, defined in the catalog are dependant |
| adSchemaProcedureParameters | 26 Returns information about the parameters and return codes of procedures. |
| adSchemaForeignKeys | 27 Returns the foreign key columns |
| adSchemaPrimaryKeys | 28 Returns the primary key columns |
| adSchemaProcedureColumns | 29 Returns information about the columns of rowsets returned by procedures. |
| adSchemaDBInfoKeywords | 30 Returns a list of provider-specific keywords. |
| adSchemaDBInfoLiterals | 31 Returns a list of provider-specific literals used in text commands. |
| adSchemaCubes | 32 Returns information about the available cubes in a schema (or the catalog, if the provider does not support schemas). |
| adSchemaDimensions | 33 Returns information about the dimensions in a given cube. It has one row for each dimension. |
| adSchemaHierarchies | 34 Returns information about the hierarchies available in a dimension. |
| adSchemaLevels | 35 Returns information about the levels available in a dimension. |
| adSchemaMeasures | 36 Returns information about the available measures. |
| adSchemaProperties | 37 Returns information about the available properties for each level of the dimension. |
| adSchemaMembers | 38 Returns information about the available members. |
| adSchemaTrustees | 39 Returns information about trustees. |
See Also
Enums, AdoEnum2Str(), AdoStr2Enum()
