Java Doc for DatabaseMetaData.java in  » Database-DBMS » Quadcap-Embeddable-Database » com » quadcap » jdbc » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Descriptions are returned only for attributes of UDTs matching the catalog, schema, type, and attribute name criteria.

Only supertable information for tables matching the catalog, schema and table name are returned.

1: TYPE_NAMEString Containing the SQL-92 name of the type2: DATA_TYPEshort Giving the JDBC type, fromjava.sql.Types3: PRECISIONint indicating the maximum precision fornumeric types, and -1 for non-numeric types4: LITERAL_PREFIXString for character types, the 'character; for other types, null5: LITERAL_SUFFIXString for character types, the 'character; for other types, null6: CREATE_PARAMSString Giving the parameters used whencreating the type.

this database supports only data manipulation statements within a transaction

Descriptions are returned only for attributes of UDTs matching the catalog, schema, type, and attribute name criteria. They are ordered by TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. This description does not contain inherited attributes.

The ResultSet object that is returned has the following columns:

1. TYPE_CAT String => type catalog (may be null)
2. TYPE_SCHEM String => type schema (may be null)
3. TYPE_NAME String => type name
4. ATTR_NAME String => attribute name
5. DATA_TYPE short => attribute type SQL type from java.sql.Types
6. ATTR_TYPE_NAME String => Data source dependent type name. For a UDT, the type name is fully qualified. For a REF, the type name is fully qualified and represents the target type of the reference type.
7. ATTR_SIZE int => column size. For char or date types this is the maximum number of characters; for numeric or decimal types this is precision.
8. DECIMAL_DIGITS int => the number of fractional digits
9. NUM_PREC_RADIX int => Radix (typically either 10 or 2)
10. NULLABLE int => whether NULL is allowed
    • attributeNoNulls - might not allow NULL values
    • attributeNullable - definitely allows NULL values
    • attributeNullableUnknown - nullability unknown
11. REMARKS String => comment describing column (may be null)
12. ATTR_DEF String => default value (may be null)
13. SQL_DATA_TYPE int => unused
14. SQL_DATETIME_SUB int => unused
15. CHAR_OCTET_LENGTH int => for char types the maximum number of bytes in the column
16. ORDINAL_POSITION int => index of column in table (starting at 1)
17. IS_NULLABLE String => "NO" means column definitely does not allow NULL values; "YES" means the column might allow NULL values. An empty string means unknown.
18. SCOPE_CATALOG String => catalog of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
19. SCOPE_SCHEMA String => schema of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
20. SCOPE_TABLE String => table name that is the scope of a reference attribute (null if the DATA_TYPE isn't REF)
21. SOURCE_DATA_TYPE short => source type of a distinct type or user-generated Ref type,SQL type from java.sql.Types (null if DATA_TYPE isn't DISTINCT or user-generated REF)

The columns in the ResultSet object have thefollowing definition:1: TABLE_CATnull (Catalogs not supported by QED)2: TABLE_SCHEMString giving the table's schema3: TABLE_NAMEString giving the table's name4: COLUMN_NAMEString giving the column name5: DATA_TYPEshort type from java.sql.types6: TYPE_NAMEString giving the SQL type7: COLUMN_SIZEint For numeric types, this is the precision; for character types, it's the maximum width8: BUFFER_LENGTHnull unused9: DECIMAL_DIGITSint For numeric types, the number of digits to the right of the decimal point. For other types, -110: NUM_PREC_RADIXint 1011: NULLABLEint One of:

• ResultSetMetaData.columnNoNulls
• ResultSetMetaData.columnNullable
• ResultSetMetaData.columnNullableUnknown

exception:
  SQLException - may be thrown.The columns in the ResultSet object have the followingdefinition:

1: PKTABLE_CATnull (Catalogs not supported by QED)2: PKTABLE_SCHEMString giving the schema of the primary key's table.3: PKTABLE_NAMEString giving the name of the primary key's table4: PKCOLUMN_NAMEString giving the column name of the primary key5: FKTABLE_CATString (An empty string in QED)6: FKTABLE_SCHEMString giving the schema of the foreign key's table.7: FKTABLE_NAMEString giving the name of the foreign key's table8: FKCOLUMN_NAMEString giving the column name of the foreign key9: KEY_SEQshort indicating the column number within the foreign key, if the foreign key hasmore than one column10: UPDATE_RULEshort indicating what happens when the primary key is updated: The values supported by QEDare:

• DatabaseMetaData.importedKeyRestrict
• DatabaseMetaData.importedKeyCascade

exception:
  SQLException - may be thrown.The columns in the ResultSet object have the followingdefinition:

1: PKTABLE_CATnull (Catalogs not supported by QED)2: PKTABLE_SCHEMString giving the schema of the primary key's table.3: PKTABLE_NAMEString giving the name of the primary key's table4: PKCOLUMN_NAMEString giving the column name of the primary key5: FKTABLE_CATnull (Catalogs not supported by QED)6: FKTABLE_SCHEMString giving the schema of the foreign key's table.7: FKTABLE_NAMEString giving the name of the foreign key's table8: FKCOLUMN_NAMEString giving the column name of the foreign key9: KEY_SEQshort indicating the column number within the foreign key, if the foreign key hasmore than one column10: UPDATE_RULEshort indicating what happens when the primary key is updated: The values supported by QEDare:

• DatabaseMetaData.importedKeyRestrict
• DatabaseMetaData.importedKeyCascade

exception:
  SQLException - may be thrown.The columns in the ResultSet object have the followingdefinition:

1: PKTABLE_CATnull (Catalogs not supported by QED)2: PKTABLE_SCHEMString giving the schema of the primary key's table.3: PKTABLE_NAMEString giving the name of the primary key's table4: PKCOLUMN_NAMEString giving the column name of the primary key5: FKTABLE_CATnull (Catalogs not supported by QED)6: FKTABLE_SCHEMString giving the schema of the foreign key's table.7: FKTABLE_NAMEString giving the name of the foreign key's table8: FKCOLUMN_NAMEString giving the column name of the foreign key9: KEY_SEQshort indicating the column number within the foreign key, if the foreign key hasmore than one column10: UPDATE_RULEshort indicating what happens when the primary key is updated: The values supported by QEDare:

• DatabaseMetaData.importedKeyRestrict
• DatabaseMetaData.importedKeyCascade

exception:
  SQLException - may be thrown.The columns in the ResultSet object have the followingdefinition:

1: TABLE_CATnull (Catalogs not supported by QED)2: TABLE_SCHEMString giving the table's schema3: TABLE_NAMEString giving the table's name4: NON_UNIQUEboolean false if index values must be unique, true otherwise.5: INDEX_QUALIFIERQED returns "global" if this is a globalindex, null otherwise.6: INDEX_NAMEString the name of the index7: TYPEshort DatabaseMetaData.tableIndexOther8: ORDINAL_POSITIONshort indicating the column sequencewithin the index9: COLUMN_NAMEString The name of the column10: ASC_OR_DESCString always "A"11: CARDINALITYnull The JDBC specification says that this returns the number of unique values in the index,a statistic which is not kept in this release ofQED.12: PAGESnull The JDBC specification says that this returns the number of pages used by the index,a statistic which is not kept in this release ofQED.13: FILTER_CONDITIONnull not supported by QED

ABS,ACOS,ASIN,ATAN,ATAN2,CEILING,COS,COT,DEGREES,EXP,FLOOR LOG,LOG10,MOD,PI,POWER,RADIANS,RAND,ROUND,SIGN,SIN,SQRT,TAN TRUNCATE

exception:
  SQLException - may be thrown.The columns in the ResultSet object have the followingdefinition:

1: TABLE_CATnull (Catalogs not supported by QED)2: TABLE_SCHEMString giving the table's schema3: TABLE_NAMEString giving the table's name4: COLUMN_NAMEString giving the column name5: KEY_SEQshort indicating the column sequencewithin the primary key6: PK_NAMEString The name of the primary key constraint

ASCII, CHAR, CONCAT, DIFFERENCE, INSERT, LCASE, LOWER, LEFT, LENGTH LOCATE, LTRIM, REPEAT, REPLACE, RIGHT, RTRIM, SOUNDEX, SPACE SUBSTRING, UCASE, UPPER

Only supertable information for tables matching the catalog, schema and table name are returned. The table name parameter may be a fully- qualified name, in which case, the catalog and schemaPattern parameters are ignored. If a table does not have a super table, it is not listed here. Supertables have to be defined in the same catalog and schema as the sub tables. Therefore, the type description does not need to include this information for the supertable.

Each type description has the following columns:

1. TABLE_CAT String => the type's catalog (may be null)
2. TABLE_SCHEM String => type's schema (may be null)
3. TABLE_NAME String => type name
4. SUPERTABLE_NAME String => the direct super type's name

Note: If the driver does not support type hierarchies, an empty result set is returned.
Parameters:
  catalog - a catalog name; "" retrieves those without a catalog;null means drop catalog name from the selectioncriteria
Parameters:
  schemaPattern - a schema name pattern; "" retrieves those without a schema
Parameters:
  tableNamePattern - a table name pattern; may be a fully-qualifiedname a ResultSet object in which each row is a typedescription
throws:
  SQLException - if a database access error occurs
since:
   1.4

Only supertype information for UDTs matching the catalog, schema, and type name is returned. The type name parameter may be a fully-qualified name. When the UDT name supplied is a fully-qualified name, the catalog and schemaPattern parameters are ignored.

If a UDT does not have a direct super type, it is not listed here. A row of the ResultSet object returned by this method describes the designated UDT and a direct supertype. A row has the following columns:

1. TYPE_CAT String => the UDT's catalog (may be null)
2. TYPE_SCHEM String => UDT's schema (may be null)
3. TYPE_NAME String => type name of the UDT
4. SUPERTYPE_CAT String => the direct super type's catalog (may be null)
5. SUPERTYPE_SCHEM String => the direct super type's schema (may be null)
6. SUPERTYPE_NAME String => the direct super type's name

Note: If the driver does not support type hierarchies, an empty result set is returned.
Parameters:
  catalog - a catalog name; "" retrieves those without a catalog;null means drop catalog name from the selectioncriteria
Parameters:
  schemaPattern - a schema name pattern; "" retrieves those without a schema
Parameters:
  typeNamePattern - a UDT name pattern; may be a fully-qualifiedname a ResultSet object in which a row gives informationabout the designated UDT
throws:
  SQLException - if a database access error occurs
since:
   1.4

DATABASE, IFNULL, USER

1: TABLE_TYPEString listing the table type.One of:

• TABLE
• VIEW
• GLOBAL TEMPORARY
• LOCAL TEMPORARY

CURDATE,CURTIME,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR HOUR,MINUTE,MONTH,MONTHNAME,NOW,QUARTER,SECOND,TIMESTAMPADD TIMESTAMPDIFF,WEEK,YEAR

1: TYPE_NAMEString Containing the SQL-92 name of the type2: DATA_TYPEshort Giving the JDBC type, fromjava.sql.Types3: PRECISIONint indicating the maximum precision fornumeric types, and -1 for non-numeric types4: LITERAL_PREFIXString for character types, the 'character; for other types, null5: LITERAL_SUFFIXString for character types, the 'character; for other types, null6: CREATE_PARAMSString Giving the parameters used whencreating the type. Typically, for character types,"length", and for numeric types, "precision" 7: NULLABLEint indicating whether a type is nullable.All types are nullable in QED, so this alwayscontains DatabaseMetaData.typeNullable.8: CASE_SENSITIVEboolean if the type is case-sensitive.Always true in QED.9: SEARCHABLEshort indicating if this type can be usedin a WHERE clause. QED always returnsDatabaseMetaData.typeSearchable10: UNSIGNED_ATTRIBUTEboolean true ifthis type is unsigned, false otherwise11: FIXED_PREC_SCALEboolean true ifthis type can be a currency value12: AUTO_INCREMENTfalse in QED, no auto-increment typesare supported.13: LOCAL_TYPE_NAMEnull14: MINIMUM_SCALEshort indicating the minimum scalesupported for tthis type15: MAXIMUM_SCALEshort indicating the maximum scalesupported for tthis type16: SQL_DATA_TYPEint null17: SQL_DATETIME_SUBint null18: NUM_PREC_RADIXint 10

1. A row that has been inserted appears in the ResultSet object without having to close and reopen it
and
2. The method ResultSet.rowInserted will return true if the current row was one inserted after the ResultSet was opened

This release of QED always returns false to ResultSet.rowInserted.
Parameters:
  type - the type of ResultSet false

• Bit Strings, Timestamps with explicit precision
• UPPER(), LOWER()
• CROSS JOIN, UNION JOIN
• IS [NOT] {TRUE|FALSE|UNKNOWN}
• MATCH conditions in foreign key constraints
• TABLE table

• CONNECT, SET CONNECTION, DISCONNECT
• SET CATALOG (or catalogs at all), SET SCHEMA, SET NAMES
• POSITION()
• CREATE ASSERTION, DROP ASSERTION
• ON UPDATE in foreign key constraints
• TEMPORARY tables

• Long identifiers, lowercase identifiers, named constraints
• Datetimes, intervals
• CHARACTER_LENGTH(), OCTET_LENGTH(), SUBSTRING(), TRIM(), CAST()
• JOIN, EXCEPT, INTERSECT, UNION CORRESPONDING
• SELECT AS, SELECT column-commalist, SELECT X.*
• UNIQUE
• ALTER TABLE, DROP TABLE, DROP VIEW
• Many other entry level restrictions are relaxed.

• CURRENT_USER(), SYSTEM_USER()
• DROP SCHEMA
• ON DELETE in foreign key definitions
• Dynamic SQL, explicit SQL CURSOR support (e.g., FOR UPDATE), anything that basically overlaps with JDBC functionality.
false

this database supports only data manipulation statements within a transaction