The '_' character represents any single character.

The '%' character represents any sequence of zero or more characters.

The SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.

Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.

Each procedure description has the following columns:

1. PROCEDURE_CAT string => procedure catalog (may be NULL)
2. PROCEDURE_SCHEM string => procedure schema (may be NULL)
3. PROCEDURE_NAME string => procedure name
4. reserved for future use
5. reserved for future use
6. reserved for future use
7. REMARKS string => explanatory comment on the procedure
8. PROCEDURE_TYPE short => kind of procedure:
   • UNKNOWN - May return a result
   • NO - Does not return a result
   • RETURN - Returns a result

Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.

Each row in the XResultSet is a parameter description or column description with the following fields:

1. PROCEDURE_CAT string => procedure catalog (may be NULL)
2. PROCEDURE_SCHEM string => procedure schema (may be NULL)
3. PROCEDURE_NAME string => procedure name
4. COLUMN_NAME string => column/parameter name
5. COLUMN_TYPE Short => kind of column/parameter:
   • UNKNOWN - nobody knows
   • IN - IN parameter
   • INOUT - INOUT parameter
   • OUT - OUT parameter
   • RETURN - procedure return value
   • RESULT - result column in XResultSet
6. DATA_TYPE short => SQL type from java.sql.Types
7. TYPE_NAME string => SQL type name, for a UDT type the type name is fully qualified
8. PRECISION long => precision
9. LENGTH long => length in bytes of data
10. SCALE short => scale
11. RADIX short => radix
12. NULLABLE short => can it contain NULL?
    • NO_NULLS - does not allow NULL values
    • NULLABLE - allows NULL values
    • NULLABLE_UNKNOWN - nullability unknown
13. REMARKS string => comment describing parameter/column

Note: Some databases may not return the column descriptions for a procedure. Additional columns beyond REMARKS can be defined by the database.

Only table descriptions matching the catalog, schema, table name, and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM, and TABLE_NAME.

Each table description has the following columns:

1. TABLE_CAT string => table catalog (may be NULL)
2. TABLE_SCHEM string => table schema (may be NULL)
3. TABLE_NAME string => table name
4. TABLE_TYPE string => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
5. REMARKS string => explanatory comment on the table

Note: Some databases may not return information for all tables.

The schema column is:

1. TABLE_SCHEM string => schema name

The catalog column is:

1. TABLE_CAT string => catalog name

The table type is:

1. TABLE_TYPE string => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION.

Each column description has the following columns:

1. TABLE_CAT string => table catalog (may be NULL)
2. TABLE_SCHEM string => table schema (may be NULL)
3. TABLE_NAME string => table name
4. COLUMN_NAME string => column name
5. DATA_TYPE short => SQL type from java.sql.Types
6. TYPE_NAME string => Data source dependent type name, for a UDT the type name is fully qualified
7. COLUMN_SIZE long => column size. For char or date types this is the maximum number of characters, for numeric or decimal types this is precision.
8. BUFFER_LENGTH is not used.
9. DECIMAL_DIGITS long => the number of fractional digits
10. NUM_PREC_RADIX long => Radix (typically either 10 or 2)
11. NULLABLE long => is NULL allowed?
    • NO_NULLS - might not allow NULL values
    • NULABLE - definitely allows NULL values
    • NULLABLE_UNKNOWN - nullability unknown
12. REMARKS string => comment describing column (may be NULL)
13. COLUMN_DEF string => default value (may be NULL)
14. SQL_DATA_TYPE long => unused
15. SQL_DATETIME_SUB long => unused
16. CHAR_OCTET_LENGTH long => for char types the maximum number of bytes in the column
17. ORDINAL_POSITION int => index of column in table (starting at 1)
18. IS_NULLABLE string => "NO" means column definitely does not allow NULL values; "YES" means the column might allow NULL values. An empty string means nobody knows.

Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.

Each privilige description has the following columns:

1. TABLE_CAT string => table catalog (may be NULL)
2. TABLE_SCHEM string => table schema (may be NULL)
3. TABLE_NAME string => table name
4. COLUMN_NAME string => column name
5. GRANTOR => grantor of access (may be NULL)
6. GRANTEE string => grantee of access
7. PRIVILEGE string => name of access (SELECT, INSERT, UPDATE, REFERENCES, ...)
8. IS_GRANTABLE string => "YES" if grantee is permitted to grant to others; "NO" if not; NULL if unknown

Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.

Each privilige description has the following columns:

1. TABLE_CAT string => table catalog (may be NULL)
2. TABLE_SCHEM string => table schema (may be NULL)
3. TABLE_NAME string => table name
4. GRANTOR => grantor of access (may be NULL)
5. GRANTEE string => grantee of access
6. PRIVILEGE string => name of access (SELECT, INSERT, UPDATE, REFERENCES, ...)
7. IS_GRANTABLE string => "YES" if grantee is permitted to grant to others; "NO" if not; NULL if unknown

Each column description has the following columns:

1. SCOPE short => actual scope of result
   • TEMPORARY - very temporary, while using row
   • TRANSACTION - valid for remainder of current transaction
   • SESSION - valid for remainder of current session
2. COLUMN_NAME string => column name
3. DATA_TYPE short => SQL data type from java.sql.Types
4. TYPE_NAME string => Data source dependent type name, for a UDT the type name is fully qualified
5. COLUMN_SIZE long => precision
6. BUFFER_LENGTH long => not used
7. DECIMAL_DIGITS short => scale
8. PSEUDO_COLUMN short => is this a pseudo column like an Oracle ROWID
   • UNKNOWN - may or may not be pseudo column
   • NOT_PSEUDO - is NOT a pseudo column
   • PSEUDO - is a pseudo column

Each column description has the following columns:

1. SCOPE short => is not used
2. COLUMN_NAME string => column name
3. DATA_TYPE short => SQL data type from java.sql.Types
4. TYPE_NAME string => Data source dependent type name
5. COLUMN_SIZE long => precision
6. BUFFER_LENGTH long => length of column value in bytes
7. DECIMAL_DIGITS short => scale
8. PSEUDO_COLUMN short => is this a pseudo column like an Oracle ROWID
   • UNKNOWN - may or may not be pseudo column
   • NOT_PSEUDO - is NOT a pseudo column
   • PSEUDO - is a pseudo column

Each primary key column description has the following columns:

1. TABLE_CAT string => table catalog (may be NULL)
2. TABLE_SCHEM string => table schema (may be NULL)
3. TABLE_NAME string => table name
4. COLUMN_NAME string => column name
5. KEY_SEQ short => sequence number within primary key
6. PK_NAME string => primary key name (may be NULL)

Each primary key column description has the following columns:

1. PKTABLE_CAT string => primary key table catalog being imported (may be NULL)
2. PKTABLE_SCHEM string => primary key table schema being imported (may be NULL)
3. PKTABLE_NAME string => primary key table name being imported
4. PKCOLUMN_NAME string => primary key column name being imported
5. FKTABLE_CAT string => foreign key table catalog (may be NULL)
6. FKTABLE_SCHEM string => foreign key table schema (may be NULL)
7. FKTABLE_NAME string => foreign key table name
8. FKCOLUMN_NAME string => foreign key column name
9. KEY_SEQ short => sequence number within foreign key
10. UPDATE_RULE short => What happens to foreign key when primary is updated:
    • importedNoAction - do not allow update of primary key if it has been imported
    • importedKeyCascade - change imported key to agree with primary key update
    • importedKeySetNull - change imported key to NULL if its primary key has been updated
    • importedKeySetDefault - change imported key to default values if its primary key has been updated
    • importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
11. DELETE_RULE short => What happens to the foreign key when primary is deleted.
    • importedKeyNoAction - do not allow delete of primary key if it has been imported
    • importedKeyCascade - delete rows that import a deleted key
    • importedKeySetNull - change imported key to NULL if its primary key has been deleted
    • importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
    • importedKeySetDefault - change imported key to default if its primary key has been deleted
12. FK_NAME string => foreign key name (may be NULL)
13. PK_NAME string => primary key name (may be NULL)
14. DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
    • importedKeyInitiallyDeferred - see SQL92 for definition
    • importedKeyInitiallyImmediate - see SQL92 for definition
    • importedKeyNotDeferrable - see SQL92 for definition

Each foreign key column description has the following columns:

1. PKTABLE_CAT string => primary key table catalog (may be NULL)
2. PKTABLE_SCHEM string => primary key table schema (may be NULL)
3. PKTABLE_NAME string => primary key table name
4. PKCOLUMN_NAME string => primary key column name
5. FKTABLE_CAT string => foreign key table catalog (may be NULL) being exported (may be NULL)
6. FKTABLE_SCHEM string => foreign key table schema (may be NULL) being exported (may be NULL)
7. FKTABLE_NAME string => foreign key table name being exported
8. FKCOLUMN_NAME string => foreign key column name being exported
9. KEY_SEQ short => sequence number within foreign key
10. UPDATE_RULE short => What happens to foreign key when primary is updated:
    • NO_ACTION - do not allow update of primary key if it has been imported
    • CASCADE - change imported key to agree with primary key update
    • SET_NULL - change imported key to NULL if its primary key has been updated
    • SET_DEFAULT - change imported key to default values if its primary key has been updated
    • RESTRICT - same as importedKeyNoAction (for ODBC 2.x compatibility)
11. DELETE_RULE short => What happens to the foreign key when primary is deleted.
    • NO_ACTION - do not allow delete of primary key if it has been imported
    • CASCADE - delete rows that import a deleted key
    • SET_NULL - change imported key to NULL if its primary key has been deleted
    • RESTRICT - same as importedKeyNoAction (for ODBC 2.x compatibility)
    • SET_DEFAULT - change imported key to default if its primary key has been deleted
12. FK_NAME string => foreign key name (may be NULL)
13. PK_NAME string => primary key name (may be NULL)
14. DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
    • INITIALLY_DEFERRED - see SQL92 for definition
    • INITIALLY_IMMEDIATE - see SQL92 for definition
    • NONE - see SQL92 for definition

Each foreign key column description has the following columns:

1. PKTABLE_CAT string => primary key table catalog (may be NULL)
2. PKTABLE_SCHEM string => primary key table schema (may be NULL)
3. PKTABLE_NAME string => primary key table name
4. PKCOLUMN_NAME string => primary key column name
5. FKTABLE_CAT string => foreign key table catalog (may be NULL) being exported (may be NULL)
6. FKTABLE_SCHEM string => foreign key table schema (may be NULL) being exported (may be NULL)
7. FKTABLE_NAME string => foreign key table name being exported
8. FKCOLUMN_NAME string => foreign key column name being exported
9. KEY_SEQ short => sequence number within foreign key
10. UPDATE_RULE short => What happens to foreign key when primary is updated:
    • NO_ACTION - do not allow update of primary key if it has been imported
    • CASCADE - change imported key to agree with primary key update
    • SET_NULL - change imported key to NULL if its primary key has been updated
    • SET_DEFAULT - change imported key to default values if its primary key has been updated
    • RESTRICT - same as importedKeyNoAction (for ODBC 2.x compatibility)
11. DELETE_RULE short => What happens to the foreign key when primary is deleted.
    • NO_ACTION - do not allow delete of primary key if it has been imported
    • CASCADE - delete rows that import a deleted key
    • SET_NULL - change imported key to NULL if its primary key has been deleted
    • RESTRICT - same as importedKeyNoAction (for ODBC 2.x compatibility)
    • SET_DEFAULT - change imported key to default if its primary key has been deleted
12. FK_NAME string => foreign key name (may be NULL)
13. PK_NAME string => primary key name (may be NULL)
14. DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
    • INITIALLY_DEFERRED - see SQL92 for definition
    • INITIALLY_IMMEDIATE - see SQL92 for definition
    • NONE - see SQL92 for definition

Each type description has the following columns:

1. TYPE_NAME string => Type name
2. DATA_TYPE short => SQL data type from java.sql.Types
3. PRECISION long => maximum precision
4. LITERAL_PREFIX string => prefix used to quote a literal (may be NULL)
5. LITERAL_SUFFIX string => suffix used to quote a literal (may be NULL)
6. CREATE_PARAMS string => parameters used in creating the type (may be NULL)
7. NULLABLE short => can you use NULL for this type?
   • NO_NULLS - does not allow NULL values
   • NULLABLE - allows NULL values
   • NULLABLE_UNKNOWN - nullability unknown
8. CASE_SENSITIVE boolean=> is it case sensitive?
9. SEARCHABLE short => can you use "WHERE" based on this type:
   • NONE - No support
   • CHAR - Only supported with WHERE .. LIKE
   • BASIC - Supported except for WHERE .. LIKE
   • FULL - Supported for all WHERE ..
10. UNSIGNED_ATTRIBUTE boolean => is it unsigned?
11. FIXED_PREC_SCALE boolean => can it be a money value?
12. AUTO_INCREMENT boolean => can it be used for an auto-increment value?
13. LOCAL_TYPE_NAME string => localized version of type name (may be NULL)
14. MINIMUM_SCALE short => minimum scale supported
15. MAXIMUM_SCALE short => maximum scale supported
16. SQL_DATA_TYPE long => unused
17. SQL_DATETIME_SUB long => unused
18. NUM_PREC_RADIX long => usually 2 or 10

Each index column description has the following columns:

1. TABLE_CAT string => table catalog (may be NULL)
2. TABLE_SCHEM string => table schema (may be NULL)
3. TABLE_NAME string => table name
4. NON_UNIQUE boolean => Can index values be non-unique? false when TYPE is tableIndexStatistic
5. INDEX_QUALIFIER string => index catalog (may be NULL); NULL when TYPE is tableIndexStatistic
6. INDEX_NAME string => index name; NULL when TYPE is tableIndexStatistic
7. TYPE short => index type:
   • 0 - this identifies table statistics that are returned in conjuction with a table's index descriptions
   • CLUSTERED - this is a clustered index
   • HASHED - this is a hashed index
   • OTHER - this is some other style of index
8. ORDINAL_POSITION short => column sequence number within index; zero when TYPE is tableIndexStatistic
9. COLUMN_NAME string => column name; NULL when TYPE is tableIndexStatistic
10. ASC_OR_DESC string => column sort sequence, "A" => ascending, "D" => descending, may be NULL if sort sequence is not supported; NULL when TYPE is tableIndexStatistic
11. CARDINALITY long => When TYPE is tableIndexStatistic, then this is the number of rows in the table; otherwise, it is the number of unique values in the index.
12. PAGES long => When TYPE is tableIndexStatisic then this is the number of pages used for the table, otherwise it is the number of pages used for the current index.
13. FILTER_CONDITION string => Filter condition, if any. (may be NULL)

Only types matching the catalog, schema, type name, and type criteria are returned. They are ordered by DATA_TYPE, TYPE_SCHEM, and TYPE_NAME. The type name parameter may be a fully-qualified name. In this case, the catalog and schemaPattern parameters are ignored.

Each type description has the following columns:

1. TYPE_CAT string => the type's catalog (may be NULL)
2. TYPE_SCHEM string => type's schema (may be NULL)
3. TYPE_NAME string => type name
4. CLASS_NAME string => Java class name or service name
5. DATA_TYPE string => type value. One of OBJECT, STRUCT, or DISTINCT
6. REMARKS string => explanatory comment on the type

Note: If the driver does not support UDTs, an empty result set is returned.