declare namespace java { namespace sql { /** * Comprehensive information about the database as a whole. *

* This interface is implemented by driver vendors to let users know the capabilities * of a Database Management System (DBMS) in combination with * the driver based on JDBC™ technology * ("JDBC driver") that is used with it. Different relational DBMSs often support * different features, implement features in different ways, and use different * data types. In addition, a driver may implement a feature on top of what the * DBMS offers. Information returned by methods in this interface applies * to the capabilities of a particular driver and a particular DBMS working * together. Note that as used in this documentation, the term "database" is * used generically to refer to both the driver and DBMS. *

* A user for this interface is commonly a tool that needs to discover how to * deal with the underlying DBMS. This is especially true for applications * that are intended to be used with more than one DBMS. For example, a tool might use the method * getTypeInfo to find out what data types can be used in a * CREATE TABLE statement. Or a user might call the method * supportsCorrelatedSubqueries to see if it is possible to use * a correlated subquery or supportsBatchUpdates to see if it is * possible to use batch updates. *

* Some DatabaseMetaData methods return lists of information * in the form of ResultSet objects. * Regular ResultSet methods, such as * getString and getInt, can be used * to retrieve the data from these ResultSet objects. If * a given form of metadata is not available, an empty ResultSet * will be returned. Additional columns beyond the columns defined to be * returned by the ResultSet object for a given method * can be defined by the JDBC driver vendor and must be accessed * by their column label. *

* Some DatabaseMetaData methods take arguments that are * String patterns. These arguments all have names such as fooPattern. * Within a pattern String, "%" means match any substring of 0 or more * characters, and "_" means match any one character. Only metadata * entries matching the search pattern are returned. If a search pattern * argument is set to null, that argument's criterion will * be dropped from the search. */ // @ts-ignore interface DatabaseMetaData extends java.sql.Wrapper { /** * Indicates that it is not known whether the procedure returns * a result. *

* A possible value for column PROCEDURE_TYPE in the * ResultSet object returned by the method * getProcedures. */ // @ts-ignore readonly procedureResultUnknown: number /*int*/ /** * Indicates that the procedure does not return a result. *

* A possible value for column PROCEDURE_TYPE in the * ResultSet object returned by the method * getProcedures. */ // @ts-ignore readonly procedureNoResult: number /*int*/ /** * Indicates that the procedure returns a result. *

* A possible value for column PROCEDURE_TYPE in the * ResultSet object returned by the method * getProcedures. */ // @ts-ignore readonly procedureReturnsResult: number /*int*/ /** * Indicates that type of the column is unknown. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureColumnUnknown: number /*int*/ /** * Indicates that the column stores IN parameters. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureColumnIn: number /*int*/ /** * Indicates that the column stores INOUT parameters. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureColumnInOut: number /*int*/ /** * Indicates that the column stores OUT parameters. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureColumnOut: number /*int*/ /** * Indicates that the column stores return values. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureColumnReturn: number /*int*/ /** * Indicates that the column stores results. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureColumnResult: number /*int*/ /** * Indicates that NULL values are not allowed. *

* A possible value for the column * NULLABLE * in the ResultSet object * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureNoNulls: number /*int*/ /** * Indicates that NULL values are allowed. *

* A possible value for the column * NULLABLE * in the ResultSet object * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureNullable: number /*int*/ /** * Indicates that whether NULL values are allowed * is unknown. *

* A possible value for the column * NULLABLE * in the ResultSet object * returned by the method getProcedureColumns. */ // @ts-ignore readonly procedureNullableUnknown: number /*int*/ /** * Indicates that the column might not allow NULL values. *

* A possible value for the column * NULLABLE * in the ResultSet returned by the method * getColumns. */ // @ts-ignore readonly columnNoNulls: number /*int*/ /** * Indicates that the column definitely allows NULL values. *

* A possible value for the column * NULLABLE * in the ResultSet returned by the method * getColumns. */ // @ts-ignore readonly columnNullable: number /*int*/ /** * Indicates that the nullability of columns is unknown. *

* A possible value for the column * NULLABLE * in the ResultSet returned by the method * getColumns. */ // @ts-ignore readonly columnNullableUnknown: number /*int*/ /** * Indicates that the scope of the best row identifier is * very temporary, lasting only while the * row is being used. *

* A possible value for the column * SCOPE * in the ResultSet object * returned by the method getBestRowIdentifier. */ // @ts-ignore readonly bestRowTemporary: number /*int*/ /** * Indicates that the scope of the best row identifier is * the remainder of the current transaction. *

* A possible value for the column * SCOPE * in the ResultSet object * returned by the method getBestRowIdentifier. */ // @ts-ignore readonly bestRowTransaction: number /*int*/ /** * Indicates that the scope of the best row identifier is * the remainder of the current session. *

* A possible value for the column * SCOPE * in the ResultSet object * returned by the method getBestRowIdentifier. */ // @ts-ignore readonly bestRowSession: number /*int*/ /** * Indicates that the best row identifier may or may not be a pseudo column. *

* A possible value for the column * PSEUDO_COLUMN * in the ResultSet object * returned by the method getBestRowIdentifier. */ // @ts-ignore readonly bestRowUnknown: number /*int*/ /** * Indicates that the best row identifier is NOT a pseudo column. *

* A possible value for the column * PSEUDO_COLUMN * in the ResultSet object * returned by the method getBestRowIdentifier. */ // @ts-ignore readonly bestRowNotPseudo: number /*int*/ /** * Indicates that the best row identifier is a pseudo column. *

* A possible value for the column * PSEUDO_COLUMN * in the ResultSet object * returned by the method getBestRowIdentifier. */ // @ts-ignore readonly bestRowPseudo: number /*int*/ /** * Indicates that this version column may or may not be a pseudo column. *

* A possible value for the column * PSEUDO_COLUMN * in the ResultSet object * returned by the method getVersionColumns. */ // @ts-ignore readonly versionColumnUnknown: number /*int*/ /** * Indicates that this version column is NOT a pseudo column. *

* A possible value for the column * PSEUDO_COLUMN * in the ResultSet object * returned by the method getVersionColumns. */ // @ts-ignore readonly versionColumnNotPseudo: number /*int*/ /** * Indicates that this version column is a pseudo column. *

* A possible value for the column * PSEUDO_COLUMN * in the ResultSet object * returned by the method getVersionColumns. */ // @ts-ignore readonly versionColumnPseudo: number /*int*/ /** * For the column UPDATE_RULE, * indicates that * when the primary key is updated, the foreign key (imported key) * is changed to agree with it. * For the column DELETE_RULE, * it indicates that * when the primary key is deleted, rows that imported that key * are deleted. *

* A possible value for the columns UPDATE_RULE * and DELETE_RULE in the * ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeyCascade: number /*int*/ /** * For the column UPDATE_RULE, indicates that * a primary key may not be updated if it has been imported by * another table as a foreign key. * For the column DELETE_RULE, indicates that * a primary key may not be deleted if it has been imported by * another table as a foreign key. *

* A possible value for the columns UPDATE_RULE * and DELETE_RULE in the * ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeyRestrict: number /*int*/ /** * For the columns UPDATE_RULE * and DELETE_RULE, indicates that * when the primary key is updated or deleted, the foreign key (imported key) * is changed to NULL. *

* A possible value for the columns UPDATE_RULE * and DELETE_RULE in the * ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeySetNull: number /*int*/ /** * For the columns UPDATE_RULE * and DELETE_RULE, indicates that * if the primary key has been imported, it cannot be updated or deleted. *

* A possible value for the columns UPDATE_RULE * and DELETE_RULE in the * ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeyNoAction: number /*int*/ /** * For the columns UPDATE_RULE * and DELETE_RULE, indicates that * if the primary key is updated or deleted, the foreign key (imported key) * is set to the default value. *

* A possible value for the columns UPDATE_RULE * and DELETE_RULE in the * ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeySetDefault: number /*int*/ /** * Indicates deferrability. See SQL-92 for a definition. *

* A possible value for the column DEFERRABILITY * in the ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeyInitiallyDeferred: number /*int*/ /** * Indicates deferrability. See SQL-92 for a definition. *

* A possible value for the column DEFERRABILITY * in the ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeyInitiallyImmediate: number /*int*/ /** * Indicates deferrability. See SQL-92 for a definition. *

* A possible value for the column DEFERRABILITY * in the ResultSet objects returned by the methods * getImportedKeys, getExportedKeys, * and getCrossReference. */ // @ts-ignore readonly importedKeyNotDeferrable: number /*int*/ /** * Indicates that a NULL value is NOT allowed for this * data type. *

* A possible value for column NULLABLE in the * ResultSet object returned by the method * getTypeInfo. */ // @ts-ignore readonly typeNoNulls: number /*int*/ /** * Indicates that a NULL value is allowed for this * data type. *

* A possible value for column NULLABLE in the * ResultSet object returned by the method * getTypeInfo. */ // @ts-ignore readonly typeNullable: number /*int*/ /** * Indicates that it is not known whether a NULL value * is allowed for this data type. *

* A possible value for column NULLABLE in the * ResultSet object returned by the method * getTypeInfo. */ // @ts-ignore readonly typeNullableUnknown: number /*int*/ /** * Indicates that WHERE search clauses are not supported * for this type. *

* A possible value for column SEARCHABLE in the * ResultSet object returned by the method * getTypeInfo. */ // @ts-ignore readonly typePredNone: number /*int*/ /** * Indicates that the data type * can be only be used in WHERE search clauses * that use LIKE predicates. *

* A possible value for column SEARCHABLE in the * ResultSet object returned by the method * getTypeInfo. */ // @ts-ignore readonly typePredChar: number /*int*/ /** * Indicates that the data type can be only be used in WHERE * search clauses * that do not use LIKE predicates. *

* A possible value for column SEARCHABLE in the * ResultSet object returned by the method * getTypeInfo. */ // @ts-ignore readonly typePredBasic: number /*int*/ /** * Indicates that all WHERE search clauses can be * based on this type. *

* A possible value for column SEARCHABLE in the * ResultSet object returned by the method * getTypeInfo. */ // @ts-ignore readonly typeSearchable: number /*int*/ /** * Indicates that this column contains table statistics that * are returned in conjunction with a table's index descriptions. *

* A possible value for column TYPE in the * ResultSet object returned by the method * getIndexInfo. */ // @ts-ignore readonly tableIndexStatistic: number /*short*/ /** * Indicates that this table index is a clustered index. *

* A possible value for column TYPE in the * ResultSet object returned by the method * getIndexInfo. */ // @ts-ignore readonly tableIndexClustered: number /*short*/ /** * Indicates that this table index is a hashed index. *

* A possible value for column TYPE in the * ResultSet object returned by the method * getIndexInfo. */ // @ts-ignore readonly tableIndexHashed: number /*short*/ /** * Indicates that this table index is not a clustered * index, a hashed index, or table statistics; * it is something other than these. *

* A possible value for column TYPE in the * ResultSet object returned by the method * getIndexInfo. */ // @ts-ignore readonly tableIndexOther: number /*short*/ /** * Indicates that NULL values might not be allowed. *

* A possible value for the column * NULLABLE in the ResultSet object * returned by the method getAttributes. */ // @ts-ignore readonly attributeNoNulls: number /*short*/ /** * Indicates that NULL values are definitely allowed. *

* A possible value for the column NULLABLE * in the ResultSet object * returned by the method getAttributes. */ // @ts-ignore readonly attributeNullable: number /*short*/ /** * Indicates that whether NULL values are allowed is not * known. *

* A possible value for the column NULLABLE * in the ResultSet object * returned by the method getAttributes. */ // @ts-ignore readonly attributeNullableUnknown: number /*short*/ /** * A possible return value for the method * DatabaseMetaData.getSQLStateType which is used to indicate * whether the value returned by the method * SQLException.getSQLState is an * X/Open (now know as Open Group) SQL CLI SQLSTATE value. *

* @since 1.4 */ // @ts-ignore readonly sqlStateXOpen: number /*int*/ /** * A possible return value for the method * DatabaseMetaData.getSQLStateType which is used to indicate * whether the value returned by the method * SQLException.getSQLState is an SQLSTATE value. *

* @since 1.6 */ // @ts-ignore readonly sqlStateSQL: number /*int*/ /** * A possible return value for the method * DatabaseMetaData.getSQLStateType which is used to indicate * whether the value returned by the method * SQLException.getSQLState is an SQL99 SQLSTATE value. *

* Note:This constant remains only for compatibility reasons. Developers * should use the constant sqlStateSQL instead. * @since 1.4 */ // @ts-ignore readonly sqlStateSQL99: number /*int*/ /** * Indicates that type of the parameter or column is unknown. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getFunctionColumns. */ // @ts-ignore readonly functionColumnUnknown: number /*int*/ /** * Indicates that the parameter or column is an IN parameter. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionColumnIn: number /*int*/ /** * Indicates that the parameter or column is an INOUT parameter. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionColumnInOut: number /*int*/ /** * Indicates that the parameter or column is an OUT parameter. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionColumnOut: number /*int*/ /** * Indicates that the parameter or column is a return value. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionReturn: number /*int*/ /** * Indicates that the parameter or column is a column in a result set. *

* A possible value for the column * COLUMN_TYPE * in the ResultSet * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionColumnResult: number /*int*/ /** * Indicates that NULL values are not allowed. *

* A possible value for the column * NULLABLE * in the ResultSet object * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionNoNulls: number /*int*/ /** * Indicates that NULL values are allowed. *

* A possible value for the column * NULLABLE * in the ResultSet object * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionNullable: number /*int*/ /** * Indicates that whether NULL values are allowed * is unknown. *

* A possible value for the column * NULLABLE * in the ResultSet object * returned by the method getFunctionColumns. * @since 1.6 */ // @ts-ignore readonly functionNullableUnknown: number /*int*/ /** * Indicates that it is not known whether the function returns * a result or a table. *

* A possible value for column FUNCTION_TYPE in the * ResultSet object returned by the method * getFunctions. * @since 1.6 */ // @ts-ignore readonly functionResultUnknown: number /*int*/ /** * Indicates that the function does not return a table. *

* A possible value for column FUNCTION_TYPE in the * ResultSet object returned by the method * getFunctions. * @since 1.6 */ // @ts-ignore readonly functionNoTable: number /*int*/ /** * Indicates that the function returns a table. *

* A possible value for column FUNCTION_TYPE in the * ResultSet object returned by the method * getFunctions. * @since 1.6 */ // @ts-ignore readonly functionReturnsTable: number /*int*/ /** * Retrieves whether the current user can call all the procedures * returned by the method getProcedures. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore allProceduresAreCallable(): boolean /** * Retrieves whether the current user can use all the tables returned * by the method getTables in a SELECT * statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore allTablesAreSelectable(): boolean /** * Retrieves the URL for this DBMS. * @return the URL for this DBMS or null if it cannot be * generated * @exception SQLException if a database access error occurs */ // @ts-ignore getURL(): string /** * Retrieves the user name as known to this database. * @return the database user name * @exception SQLException if a database access error occurs */ // @ts-ignore getUserName(): string /** * Retrieves whether this database is in read-only mode. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore isReadOnly(): boolean /** * Retrieves whether NULL values are sorted high. * Sorted high means that NULL values * sort higher than any other value in a domain. In an ascending order, * if this method returns true, NULL values * will appear at the end. By contrast, the method * nullsAreSortedAtEnd indicates whether NULL values * are sorted at the end regardless of sort order. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore nullsAreSortedHigh(): boolean /** * Retrieves whether NULL values are sorted low. * Sorted low means that NULL values * sort lower than any other value in a domain. In an ascending order, * if this method returns true, NULL values * will appear at the beginning. By contrast, the method * nullsAreSortedAtStart indicates whether NULL values * are sorted at the beginning regardless of sort order. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore nullsAreSortedLow(): boolean /** * Retrieves whether NULL values are sorted at the start regardless * of sort order. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore nullsAreSortedAtStart(): boolean /** * Retrieves whether NULL values are sorted at the end regardless of * sort order. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore nullsAreSortedAtEnd(): boolean /** * Retrieves the name of this database product. * @return database product name * @exception SQLException if a database access error occurs */ // @ts-ignore getDatabaseProductName(): string /** * Retrieves the version number of this database product. * @return database version number * @exception SQLException if a database access error occurs */ // @ts-ignore getDatabaseProductVersion(): string /** * Retrieves the name of this JDBC driver. * @return JDBC driver name * @exception SQLException if a database access error occurs */ // @ts-ignore getDriverName(): string /** * Retrieves the version number of this JDBC driver as a String. * @return JDBC driver version * @exception SQLException if a database access error occurs */ // @ts-ignore getDriverVersion(): string /** * Retrieves this JDBC driver's major version number. * @return JDBC driver major version */ // @ts-ignore getDriverMajorVersion(): number /*int*/ /** * Retrieves this JDBC driver's minor version number. * @return JDBC driver minor version number */ // @ts-ignore getDriverMinorVersion(): number /*int*/ /** * Retrieves whether this database stores tables in a local file. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore usesLocalFiles(): boolean /** * Retrieves whether this database uses a file for each table. * @return true if this database uses a local file for each table; * false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore usesLocalFilePerTable(): boolean /** * Retrieves whether this database treats mixed case unquoted SQL identifiers as * case sensitive and as a result stores them in mixed case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsMixedCaseIdentifiers(): boolean /** * Retrieves whether this database treats mixed case unquoted SQL identifiers as * case insensitive and stores them in upper case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore storesUpperCaseIdentifiers(): boolean /** * Retrieves whether this database treats mixed case unquoted SQL identifiers as * case insensitive and stores them in lower case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore storesLowerCaseIdentifiers(): boolean /** * Retrieves whether this database treats mixed case unquoted SQL identifiers as * case insensitive and stores them in mixed case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore storesMixedCaseIdentifiers(): boolean /** * Retrieves whether this database treats mixed case quoted SQL identifiers as * case sensitive and as a result stores them in mixed case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsMixedCaseQuotedIdentifiers(): boolean /** * Retrieves whether this database treats mixed case quoted SQL identifiers as * case insensitive and stores them in upper case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore storesUpperCaseQuotedIdentifiers(): boolean /** * Retrieves whether this database treats mixed case quoted SQL identifiers as * case insensitive and stores them in lower case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore storesLowerCaseQuotedIdentifiers(): boolean /** * Retrieves whether this database treats mixed case quoted SQL identifiers as * case insensitive and stores them in mixed case. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore storesMixedCaseQuotedIdentifiers(): boolean /** * Retrieves the string used to quote SQL identifiers. * This method returns a space " " if identifier quoting is not supported. * @return the quoting string or a space if quoting is not supported * @exception SQLException if a database access error occurs */ // @ts-ignore getIdentifierQuoteString(): string /** * Retrieves a comma-separated list of all of this database's SQL keywords * that are NOT also SQL:2003 keywords. * @return the list of this database's keywords that are not also * SQL:2003 keywords * @exception SQLException if a database access error occurs */ // @ts-ignore getSQLKeywords(): string /** * Retrieves a comma-separated list of math functions available with * this database. These are the Open /Open CLI math function names used in * the JDBC function escape clause. * @return the list of math functions supported by this database * @exception SQLException if a database access error occurs */ // @ts-ignore getNumericFunctions(): string /** * Retrieves a comma-separated list of string functions available with * this database. These are the Open Group CLI string function names used * in the JDBC function escape clause. * @return the list of string functions supported by this database * @exception SQLException if a database access error occurs */ // @ts-ignore getStringFunctions(): string /** * Retrieves a comma-separated list of system functions available with * this database. These are the Open Group CLI system function names used * in the JDBC function escape clause. * @return a list of system functions supported by this database * @exception SQLException if a database access error occurs */ // @ts-ignore getSystemFunctions(): string /** * Retrieves a comma-separated list of the time and date functions available * with this database. * @return the list of time and date functions supported by this database * @exception SQLException if a database access error occurs */ // @ts-ignore getTimeDateFunctions(): string /** * Retrieves the string that can be used to escape wildcard characters. * This is the string that can be used to escape '_' or '%' in * the catalog search parameters that are a pattern (and therefore use one * of the wildcard characters). *

The '_' character represents any single character; * the '%' character represents any sequence of zero or * more characters. * @return the string used to escape wildcard characters * @exception SQLException if a database access error occurs */ // @ts-ignore getSearchStringEscape(): string /** * Retrieves all the "extra" characters that can be used in unquoted * identifier names (those beyond a-z, A-Z, 0-9 and _). * @return the string containing the extra characters * @exception SQLException if a database access error occurs */ // @ts-ignore getExtraNameCharacters(): string /** * Retrieves whether this database supports ALTER TABLE * with add column. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsAlterTableWithAddColumn(): boolean /** * Retrieves whether this database supports ALTER TABLE * with drop column. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsAlterTableWithDropColumn(): boolean /** * Retrieves whether this database supports column aliasing. *

If so, the SQL AS clause can be used to provide names for * computed columns or to provide alias names for columns as * required. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsColumnAliasing(): boolean /** * Retrieves whether this database supports concatenations between * NULL and non-NULL values being * NULL. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore nullPlusNonNullIsNull(): boolean /** * Retrieves whether this database supports the JDBC scalar function * CONVERT for the conversion of one JDBC type to another. * The JDBC types are the generic SQL data types defined * in java.sql.Types. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsConvert(): boolean /** * Retrieves whether this database supports the JDBC scalar function * CONVERT for conversions between the JDBC types fromType * and toType. The JDBC types are the generic SQL data types defined * in java.sql.Types. * @param fromType the type to convert from; one of the type codes from * the class java.sql.Types * @param toType the type to convert to; one of the type codes from * the class java.sql.Types * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @see Types */ // @ts-ignore supportsConvert(fromType: number /*int*/, toType: number /*int*/): boolean /** * Retrieves whether this database supports table correlation names. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsTableCorrelationNames(): boolean /** * Retrieves whether, when table correlation names are supported, they * are restricted to being different from the names of the tables. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsDifferentTableCorrelationNames(): boolean /** * Retrieves whether this database supports expressions in * ORDER BY lists. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsExpressionsInOrderBy(): boolean /** * Retrieves whether this database supports using a column that is * not in the SELECT statement in an * ORDER BY clause. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsOrderByUnrelated(): boolean /** * Retrieves whether this database supports some form of * GROUP BY clause. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsGroupBy(): boolean /** * Retrieves whether this database supports using a column that is * not in the SELECT statement in a * GROUP BY clause. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsGroupByUnrelated(): boolean /** * Retrieves whether this database supports using columns not included in * the SELECT statement in a GROUP BY clause * provided that all of the columns in the SELECT statement * are included in the GROUP BY clause. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsGroupByBeyondSelect(): boolean /** * Retrieves whether this database supports specifying a * LIKE escape clause. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsLikeEscapeClause(): boolean /** * Retrieves whether this database supports getting multiple * ResultSet objects from a single call to the * method execute. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsMultipleResultSets(): boolean /** * Retrieves whether this database allows having multiple * transactions open at once (on different connections). * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsMultipleTransactions(): boolean /** * Retrieves whether columns in this database may be defined as non-nullable. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsNonNullableColumns(): boolean /** * Retrieves whether this database supports the ODBC Minimum SQL grammar. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsMinimumSQLGrammar(): boolean /** * Retrieves whether this database supports the ODBC Core SQL grammar. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsCoreSQLGrammar(): boolean /** * Retrieves whether this database supports the ODBC Extended SQL grammar. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsExtendedSQLGrammar(): boolean /** * Retrieves whether this database supports the ANSI92 entry level SQL * grammar. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsANSI92EntryLevelSQL(): boolean /** * Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsANSI92IntermediateSQL(): boolean /** * Retrieves whether this database supports the ANSI92 full SQL grammar supported. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsANSI92FullSQL(): boolean /** * Retrieves whether this database supports the SQL Integrity * Enhancement Facility. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsIntegrityEnhancementFacility(): boolean /** * Retrieves whether this database supports some form of outer join. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsOuterJoins(): boolean /** * Retrieves whether this database supports full nested outer joins. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsFullOuterJoins(): boolean /** * Retrieves whether this database provides limited support for outer * joins. (This will be true if the method * supportsFullOuterJoins returns true). * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsLimitedOuterJoins(): boolean /** * Retrieves the database vendor's preferred term for "schema". * @return the vendor term for "schema" * @exception SQLException if a database access error occurs */ // @ts-ignore getSchemaTerm(): string /** * Retrieves the database vendor's preferred term for "procedure". * @return the vendor term for "procedure" * @exception SQLException if a database access error occurs */ // @ts-ignore getProcedureTerm(): string /** * Retrieves the database vendor's preferred term for "catalog". * @return the vendor term for "catalog" * @exception SQLException if a database access error occurs */ // @ts-ignore getCatalogTerm(): string /** * Retrieves whether a catalog appears at the start of a fully qualified * table name. If not, the catalog appears at the end. * @return true if the catalog name appears at the beginning * of a fully qualified table name; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore isCatalogAtStart(): boolean /** * Retrieves the String that this database uses as the * separator between a catalog and table name. * @return the separator string * @exception SQLException if a database access error occurs */ // @ts-ignore getCatalogSeparator(): string /** * Retrieves whether a schema name can be used in a data manipulation statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSchemasInDataManipulation(): boolean /** * Retrieves whether a schema name can be used in a procedure call statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSchemasInProcedureCalls(): boolean /** * Retrieves whether a schema name can be used in a table definition statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSchemasInTableDefinitions(): boolean /** * Retrieves whether a schema name can be used in an index definition statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSchemasInIndexDefinitions(): boolean /** * Retrieves whether a schema name can be used in a privilege definition statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSchemasInPrivilegeDefinitions(): boolean /** * Retrieves whether a catalog name can be used in a data manipulation statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsCatalogsInDataManipulation(): boolean /** * Retrieves whether a catalog name can be used in a procedure call statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsCatalogsInProcedureCalls(): boolean /** * Retrieves whether a catalog name can be used in a table definition statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsCatalogsInTableDefinitions(): boolean /** * Retrieves whether a catalog name can be used in an index definition statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsCatalogsInIndexDefinitions(): boolean /** * Retrieves whether a catalog name can be used in a privilege definition statement. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsCatalogsInPrivilegeDefinitions(): boolean /** * Retrieves whether this database supports positioned DELETE * statements. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsPositionedDelete(): boolean /** * Retrieves whether this database supports positioned UPDATE * statements. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsPositionedUpdate(): boolean /** * Retrieves whether this database supports SELECT FOR UPDATE * statements. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSelectForUpdate(): boolean /** * Retrieves whether this database supports stored procedure calls * that use the stored procedure escape syntax. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsStoredProcedures(): boolean /** * Retrieves whether this database supports subqueries in comparison * expressions. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSubqueriesInComparisons(): boolean /** * Retrieves whether this database supports subqueries in * EXISTS expressions. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSubqueriesInExists(): boolean /** * Retrieves whether this database supports subqueries in * IN expressions. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSubqueriesInIns(): boolean /** * Retrieves whether this database supports subqueries in quantified * expressions. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsSubqueriesInQuantifieds(): boolean /** * Retrieves whether this database supports correlated subqueries. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsCorrelatedSubqueries(): boolean /** * Retrieves whether this database supports SQL UNION. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsUnion(): boolean /** * Retrieves whether this database supports SQL UNION ALL. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsUnionAll(): boolean /** * Retrieves whether this database supports keeping cursors open * across commits. * @return true if cursors always remain open; * false if they might not remain open * @exception SQLException if a database access error occurs */ // @ts-ignore supportsOpenCursorsAcrossCommit(): boolean /** * Retrieves whether this database supports keeping cursors open * across rollbacks. * @return true if cursors always remain open; * false if they might not remain open * @exception SQLException if a database access error occurs */ // @ts-ignore supportsOpenCursorsAcrossRollback(): boolean /** * Retrieves whether this database supports keeping statements open * across commits. * @return true if statements always remain open; * false if they might not remain open * @exception SQLException if a database access error occurs */ // @ts-ignore supportsOpenStatementsAcrossCommit(): boolean /** * Retrieves whether this database supports keeping statements open * across rollbacks. * @return true if statements always remain open; * false if they might not remain open * @exception SQLException if a database access error occurs */ // @ts-ignore supportsOpenStatementsAcrossRollback(): boolean /** * Retrieves the maximum number of hex characters this database allows in an * inline binary literal. * @return max the maximum length (in hex characters) for a binary literal; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxBinaryLiteralLength(): number /*int*/ /** * Retrieves the maximum number of characters this database allows * for a character literal. * @return the maximum number of characters allowed for a character literal; * a result of zero means that there is no limit or the limit is * not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxCharLiteralLength(): number /*int*/ /** * Retrieves the maximum number of characters this database allows * for a column name. * @return the maximum number of characters allowed for a column name; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxColumnNameLength(): number /*int*/ /** * Retrieves the maximum number of columns this database allows in a * GROUP BY clause. * @return the maximum number of columns allowed; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxColumnsInGroupBy(): number /*int*/ /** * Retrieves the maximum number of columns this database allows in an index. * @return the maximum number of columns allowed; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxColumnsInIndex(): number /*int*/ /** * Retrieves the maximum number of columns this database allows in an * ORDER BY clause. * @return the maximum number of columns allowed; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxColumnsInOrderBy(): number /*int*/ /** * Retrieves the maximum number of columns this database allows in a * SELECT list. * @return the maximum number of columns allowed; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxColumnsInSelect(): number /*int*/ /** * Retrieves the maximum number of columns this database allows in a table. * @return the maximum number of columns allowed; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxColumnsInTable(): number /*int*/ /** * Retrieves the maximum number of concurrent connections to this * database that are possible. * @return the maximum number of active connections possible at one time; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxConnections(): number /*int*/ /** * Retrieves the maximum number of characters that this database allows in a * cursor name. * @return the maximum number of characters allowed in a cursor name; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxCursorNameLength(): number /*int*/ /** * Retrieves the maximum number of bytes this database allows for an * index, including all of the parts of the index. * @return the maximum number of bytes allowed; this limit includes the * composite of all the constituent parts of the index; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxIndexLength(): number /*int*/ /** * Retrieves the maximum number of characters that this database allows in a * schema name. * @return the maximum number of characters allowed in a schema name; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxSchemaNameLength(): number /*int*/ /** * Retrieves the maximum number of characters that this database allows in a * procedure name. * @return the maximum number of characters allowed in a procedure name; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxProcedureNameLength(): number /*int*/ /** * Retrieves the maximum number of characters that this database allows in a * catalog name. * @return the maximum number of characters allowed in a catalog name; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxCatalogNameLength(): number /*int*/ /** * Retrieves the maximum number of bytes this database allows in * a single row. * @return the maximum number of bytes allowed for a row; a result of * zero means that there is no limit or the limit is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxRowSize(): number /*int*/ /** * Retrieves whether the return value for the method * getMaxRowSize includes the SQL data types * LONGVARCHAR and LONGVARBINARY. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore doesMaxRowSizeIncludeBlobs(): boolean /** * Retrieves the maximum number of characters this database allows in * an SQL statement. * @return the maximum number of characters allowed for an SQL statement; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxStatementLength(): number /*int*/ /** * Retrieves the maximum number of active statements to this database * that can be open at the same time. * @return the maximum number of statements that can be open at one time; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxStatements(): number /*int*/ /** * Retrieves the maximum number of characters this database allows in * a table name. * @return the maximum number of characters allowed for a table name; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxTableNameLength(): number /*int*/ /** * Retrieves the maximum number of tables this database allows in a * SELECT statement. * @return the maximum number of tables allowed in a SELECT * statement; a result of zero means that there is no limit or * the limit is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxTablesInSelect(): number /*int*/ /** * Retrieves the maximum number of characters this database allows in * a user name. * @return the maximum number of characters allowed for a user name; * a result of zero means that there is no limit or the limit * is not known * @exception SQLException if a database access error occurs */ // @ts-ignore getMaxUserNameLength(): number /*int*/ /** * Retrieves this database's default transaction isolation level. The * possible values are defined in java.sql.Connection. * @return the default isolation level * @exception SQLException if a database access error occurs * @see Connection */ // @ts-ignore getDefaultTransactionIsolation(): number /*int*/ /** * Retrieves whether this database supports transactions. If not, invoking the * method commit is a noop, and the isolation level is * TRANSACTION_NONE. * @return true if transactions are supported; * false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsTransactions(): boolean /** * Retrieves whether this database supports the given transaction isolation level. * @param level one of the transaction isolation levels defined in * java.sql.Connection * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @see Connection */ // @ts-ignore supportsTransactionIsolationLevel(level: number /*int*/): boolean /** * Retrieves whether this database supports both data definition and * data manipulation statements within a transaction. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsDataDefinitionAndDataManipulationTransactions(): boolean /** * Retrieves whether this database supports only data manipulation * statements within a transaction. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore supportsDataManipulationTransactionsOnly(): boolean /** * Retrieves whether a data definition statement within a transaction forces * the transaction to commit. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore dataDefinitionCausesTransactionCommit(): boolean /** * Retrieves whether this database ignores a data definition statement * within a transaction. * @return true if so; false otherwise * @exception SQLException if a database access error occurs */ // @ts-ignore dataDefinitionIgnoredInTransactions(): boolean /** * Retrieves a description of the stored procedures available in the given * catalog. *

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

Each procedure description has the the following columns: *

    *
  1. PROCEDURE_CAT String {@code =>} procedure catalog (may be null) *
  2. PROCEDURE_SCHEM String {@code =>} procedure schema (may be null) *
  3. PROCEDURE_NAME String {@code =>} procedure name *
  4. reserved for future use *
  5. reserved for future use *
  6. reserved for future use *
  7. REMARKS String {@code =>} explanatory comment on the procedure *
  8. PROCEDURE_TYPE short {@code =>} kind of procedure: * *
  9. SPECIFIC_NAME String {@code =>} The name which uniquely identifies this * procedure within its schema. *
*

* A user may not have permissions to execute any of the procedures that are * returned by getProcedures * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param procedureNamePattern a procedure name pattern; must match the * procedure name as it is stored in the database * @return ResultSet - each row is a procedure description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape */ // @ts-ignore getProcedures(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, procedureNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the given catalog's stored procedure parameter * and result columns. *

Only descriptions matching the schema, procedure and * parameter name criteria are returned. They are ordered by * PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME and SPECIFIC_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 ResultSet is a parameter description or * column description with the following fields: *

    *
  1. PROCEDURE_CAT String {@code =>} procedure catalog (may be null) *
  2. PROCEDURE_SCHEM String {@code =>} procedure schema (may be null) *
  3. PROCEDURE_NAME String {@code =>} procedure name *
  4. COLUMN_NAME String {@code =>} column/parameter name *
  5. COLUMN_TYPE Short {@code =>} kind of column/parameter: * *
  6. DATA_TYPE int {@code =>} SQL type from java.sql.Types *
  7. TYPE_NAME String {@code =>} SQL type name, for a UDT type the * type name is fully qualified *
  8. PRECISION int {@code =>} precision *
  9. LENGTH int {@code =>} length in bytes of data *
  10. SCALE short {@code =>} scale - null is returned for data types where * SCALE is not applicable. *
  11. RADIX short {@code =>} radix *
  12. NULLABLE short {@code =>} can it contain NULL. * *
  13. REMARKS String {@code =>} comment describing parameter/column *
  14. COLUMN_DEF String {@code =>} default value for the column, which should be interpreted as a string when the value is enclosed in single quotes (may be null) * *
  15. SQL_DATA_TYPE int {@code =>} reserved for future use *
  16. SQL_DATETIME_SUB int {@code =>} reserved for future use *
  17. CHAR_OCTET_LENGTH int {@code =>} the maximum length of binary and character based columns. For any other datatype the returned value is a * NULL *
  18. ORDINAL_POSITION int {@code =>} the ordinal position, starting from 1, for the input and output parameters for a procedure. A value of 0 * is returned if this row describes the procedure's return value. For result set columns, it is the * ordinal position of the column in the result set starting from 1. If there are * multiple result sets, the column ordinal positions are implementation * defined. *
  19. IS_NULLABLE String {@code =>} ISO rules are used to determine the nullability for a column. * *
  20. SPECIFIC_NAME String {@code =>} the name which uniquely identifies this procedure within its schema. *
*

Note: Some databases may not return the column * descriptions for a procedure. *

The PRECISION column represents the specified column size for the given column. * For numeric data, this is the maximum precision. For character data, this is the length in characters. * For datetime datatypes, this is the length in characters of the String representation (assuming the * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, * this is the length in bytes. Null is returned for data types where the * column size is not applicable. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param procedureNamePattern a procedure name pattern; must match the * procedure name as it is stored in the database * @param columnNamePattern a column name pattern; must match the column name * as it is stored in the database * @return ResultSet - each row describes a stored procedure parameter or * column * @exception SQLException if a database access error occurs * @see #getSearchStringEscape */ // @ts-ignore getProcedureColumns(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, procedureNamePattern: java.lang.String | string, columnNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the tables available in the given catalog. * Only table descriptions matching the catalog, schema, table * name and type criteria are returned. They are ordered by * TABLE_TYPE, TABLE_CAT, * TABLE_SCHEM and TABLE_NAME. *

* Each table description has the following columns: *

    *
  1. TABLE_CAT String {@code =>} table catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} table schema (may be null) *
  3. TABLE_NAME String {@code =>} table name *
  4. TABLE_TYPE String {@code =>} table type. Typical types are "TABLE", * "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", * "LOCAL TEMPORARY", "ALIAS", "SYNONYM". *
  5. REMARKS String {@code =>} explanatory comment on the table *
  6. TYPE_CAT String {@code =>} the types catalog (may be null) *
  7. TYPE_SCHEM String {@code =>} the types schema (may be null) *
  8. TYPE_NAME String {@code =>} type name (may be null) *
  9. SELF_REFERENCING_COL_NAME String {@code =>} name of the designated * "identifier" column of a typed table (may be null) *
  10. REF_GENERATION String {@code =>} specifies how values in * SELF_REFERENCING_COL_NAME are created. Values are * "SYSTEM", "USER", "DERIVED". (may be null) *
*

Note: Some databases may not return information for * all tables. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param tableNamePattern a table name pattern; must match the * table name as it is stored in the database * @param types a list of table types, which must be from the list of table types * returned from {#link #getTableTypes},to include; null returns * all types * @return ResultSet - each row is a table description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape */ // @ts-ignore getTables(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, tableNamePattern: java.lang.String | string, types: java.lang.String[] | string[]): java.sql.ResultSet /** * Retrieves the schema names available in this database. The results * are ordered by TABLE_CATALOG and * TABLE_SCHEM. *

The schema columns are: *

    *
  1. TABLE_SCHEM String {@code =>} schema name *
  2. TABLE_CATALOG String {@code =>} catalog name (may be null) *
* @return a ResultSet object in which each row is a * schema description * @exception SQLException if a database access error occurs */ // @ts-ignore getSchemas(): java.sql.ResultSet /** * Retrieves the catalog names available in this database. The results * are ordered by catalog name. *

The catalog column is: *

    *
  1. TABLE_CAT String {@code =>} catalog name *
* @return a ResultSet object in which each row has a * single String column that is a catalog name * @exception SQLException if a database access error occurs */ // @ts-ignore getCatalogs(): java.sql.ResultSet /** * Retrieves the table types available in this database. The results * are ordered by table type. *

The table type is: *

    *
  1. TABLE_TYPE String {@code =>} table type. Typical types are "TABLE", * "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", * "LOCAL TEMPORARY", "ALIAS", "SYNONYM". *
* @return a ResultSet object in which each row has a * single String column that is a table type * @exception SQLException if a database access error occurs */ // @ts-ignore getTableTypes(): java.sql.ResultSet /** * Retrieves a description of table columns available in * the specified catalog. *

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

Each column description has the following columns: *

    *
  1. TABLE_CAT String {@code =>} table catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} table schema (may be null) *
  3. TABLE_NAME String {@code =>} table name *
  4. COLUMN_NAME String {@code =>} column name *
  5. DATA_TYPE int {@code =>} SQL type from java.sql.Types *
  6. TYPE_NAME String {@code =>} Data source dependent type name, * for a UDT the type name is fully qualified *
  7. COLUMN_SIZE int {@code =>} column size. *
  8. BUFFER_LENGTH is not used. *
  9. DECIMAL_DIGITS int {@code =>} the number of fractional digits. Null is returned for data types where * DECIMAL_DIGITS is not applicable. *
  10. NUM_PREC_RADIX int {@code =>} Radix (typically either 10 or 2) *
  11. NULLABLE int {@code =>} is NULL allowed. * *
  12. REMARKS String {@code =>} comment describing column (may be null) *
  13. COLUMN_DEF String {@code =>} default value for the column, which should be interpreted as a string when the value is enclosed in single quotes (may be null) *
  14. SQL_DATA_TYPE int {@code =>} unused *
  15. SQL_DATETIME_SUB int {@code =>} unused *
  16. CHAR_OCTET_LENGTH int {@code =>} for char types the * maximum number of bytes in the column *
  17. ORDINAL_POSITION int {@code =>} index of column in table * (starting at 1) *
  18. IS_NULLABLE String {@code =>} ISO rules are used to determine the nullability for a column. * *
  19. SCOPE_CATALOG String {@code =>} catalog of table that is the scope * of a reference attribute (null if DATA_TYPE isn't REF) *
  20. SCOPE_SCHEMA String {@code =>} schema of table that is the scope * of a reference attribute (null if the DATA_TYPE isn't REF) *
  21. SCOPE_TABLE String {@code =>} table name that this the scope * of a reference attribute (null if the DATA_TYPE isn't REF) *
  22. SOURCE_DATA_TYPE short {@code =>} 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) *
  23. IS_AUTOINCREMENT String {@code =>} Indicates whether this column is auto incremented * *
  24. IS_GENERATEDCOLUMN String {@code =>} Indicates whether this is a generated column * *
*

The COLUMN_SIZE column specifies the column size for the given column. * For numeric data, this is the maximum precision. For character data, this is the length in characters. * For datetime datatypes, this is the length in characters of the String representation (assuming the * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, * this is the length in bytes. Null is returned for data types where the * column size is not applicable. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param tableNamePattern a table name pattern; must match the * table name as it is stored in the database * @param columnNamePattern a column name pattern; must match the column * name as it is stored in the database * @return ResultSet - each row is a column description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape */ // @ts-ignore getColumns(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, tableNamePattern: java.lang.String | string, columnNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the access rights for a table's columns. *

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

Each privilege description has the following columns: *

    *
  1. TABLE_CAT String {@code =>} table catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} table schema (may be null) *
  3. TABLE_NAME String {@code =>} table name *
  4. COLUMN_NAME String {@code =>} column name *
  5. GRANTOR String {@code =>} grantor of access (may be null) *
  6. GRANTEE String {@code =>} grantee of access *
  7. PRIVILEGE String {@code =>} name of access (SELECT, * INSERT, UPDATE, REFRENCES, ...) *
  8. IS_GRANTABLE String {@code =>} "YES" if grantee is permitted * to grant to others; "NO" if not; null if unknown *
* @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schema a schema name; must match the schema name as it is * stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param table a table name; must match the table name as it is * stored in the database * @param columnNamePattern a column name pattern; must match the column * name as it is stored in the database * @return ResultSet - each row is a column privilege description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape */ // @ts-ignore getColumnPrivileges(catalog: java.lang.String | string, schema: java.lang.String | string, table: java.lang.String | string, columnNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the access rights for each table available * in a catalog. Note that a table privilege applies to one or * more columns in the table. It would be wrong to assume that * this privilege applies to all columns (this may be true for * some systems but is not true for all.) *

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

Each privilege description has the following columns: *

    *
  1. TABLE_CAT String {@code =>} table catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} table schema (may be null) *
  3. TABLE_NAME String {@code =>} table name *
  4. GRANTOR String {@code =>} grantor of access (may be null) *
  5. GRANTEE String {@code =>} grantee of access *
  6. PRIVILEGE String {@code =>} name of access (SELECT, * INSERT, UPDATE, REFRENCES, ...) *
  7. IS_GRANTABLE String {@code =>} "YES" if grantee is permitted * to grant to others; "NO" if not; null if unknown *
* @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param tableNamePattern a table name pattern; must match the * table name as it is stored in the database * @return ResultSet - each row is a table privilege description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape */ // @ts-ignore getTablePrivileges(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, tableNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of a table's optimal set of columns that * uniquely identifies a row. They are ordered by SCOPE. *

Each column description has the following columns: *

    *
  1. SCOPE short {@code =>} actual scope of result * *
  2. COLUMN_NAME String {@code =>} column name *
  3. DATA_TYPE int {@code =>} SQL data type from java.sql.Types *
  4. TYPE_NAME String {@code =>} Data source dependent type name, * for a UDT the type name is fully qualified *
  5. COLUMN_SIZE int {@code =>} precision *
  6. BUFFER_LENGTH int {@code =>} not used *
  7. DECIMAL_DIGITS short {@code =>} scale - Null is returned for data types where * DECIMAL_DIGITS is not applicable. *
  8. PSEUDO_COLUMN short {@code =>} is this a pseudo column * like an Oracle ROWID * *
*

The COLUMN_SIZE column represents the specified column size for the given column. * For numeric data, this is the maximum precision. For character data, this is the length in characters. * For datetime datatypes, this is the length in characters of the String representation (assuming the * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, * this is the length in bytes. Null is returned for data types where the * column size is not applicable. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schema a schema name; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param table a table name; must match the table name as it is stored * in the database * @param scope the scope of interest; use same values as SCOPE * @param nullable include columns that are nullable. * @return ResultSet - each row is a column description * @exception SQLException if a database access error occurs */ // @ts-ignore getBestRowIdentifier(catalog: java.lang.String | string, schema: java.lang.String | string, table: java.lang.String | string, scope: number /*int*/, nullable: boolean): java.sql.ResultSet /** * Retrieves a description of a table's columns that are automatically * updated when any value in a row is updated. They are * unordered. *

Each column description has the following columns: *

    *
  1. SCOPE short {@code =>} is not used *
  2. COLUMN_NAME String {@code =>} column name *
  3. DATA_TYPE int {@code =>} SQL data type from java.sql.Types *
  4. TYPE_NAME String {@code =>} Data source-dependent type name *
  5. COLUMN_SIZE int {@code =>} precision *
  6. BUFFER_LENGTH int {@code =>} length of column value in bytes *
  7. DECIMAL_DIGITS short {@code =>} scale - Null is returned for data types where * DECIMAL_DIGITS is not applicable. *
  8. PSEUDO_COLUMN short {@code =>} whether this is pseudo column * like an Oracle ROWID * *
*

The COLUMN_SIZE column represents the specified column size for the given column. * For numeric data, this is the maximum precision. For character data, this is the length in characters. * For datetime datatypes, this is the length in characters of the String representation (assuming the * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, * this is the length in bytes. Null is returned for data types where the * column size is not applicable. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schema a schema name; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param table a table name; must match the table name as it is stored * in the database * @return a ResultSet object in which each row is a * column description * @exception SQLException if a database access error occurs */ // @ts-ignore getVersionColumns(catalog: java.lang.String | string, schema: java.lang.String | string, table: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the given table's primary key columns. They * are ordered by COLUMN_NAME. *

Each primary key column description has the following columns: *

    *
  1. TABLE_CAT String {@code =>} table catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} table schema (may be null) *
  3. TABLE_NAME String {@code =>} table name *
  4. COLUMN_NAME String {@code =>} column name *
  5. KEY_SEQ short {@code =>} sequence number within primary key( a value * of 1 represents the first column of the primary key, a value of 2 would * represent the second column within the primary key). *
  6. PK_NAME String {@code =>} primary key name (may be null) *
* @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schema a schema name; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param table a table name; must match the table name as it is stored * in the database * @return ResultSet - each row is a primary key column description * @exception SQLException if a database access error occurs */ // @ts-ignore getPrimaryKeys(catalog: java.lang.String | string, schema: java.lang.String | string, table: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the primary key columns that are * referenced by the given table's foreign key columns (the primary keys * imported by a table). They are ordered by PKTABLE_CAT, * PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ. *

Each primary key column description has the following columns: *

    *
  1. PKTABLE_CAT String {@code =>} primary key table catalog * being imported (may be null) *
  2. PKTABLE_SCHEM String {@code =>} primary key table schema * being imported (may be null) *
  3. PKTABLE_NAME String {@code =>} primary key table name * being imported *
  4. PKCOLUMN_NAME String {@code =>} primary key column name * being imported *
  5. FKTABLE_CAT String {@code =>} foreign key table catalog (may be null) *
  6. FKTABLE_SCHEM String {@code =>} foreign key table schema (may be null) *
  7. FKTABLE_NAME String {@code =>} foreign key table name *
  8. FKCOLUMN_NAME String {@code =>} foreign key column name *
  9. KEY_SEQ short {@code =>} sequence number within a foreign key( a value * of 1 represents the first column of the foreign key, a value of 2 would * represent the second column within the foreign key). *
  10. UPDATE_RULE short {@code =>} What happens to a * foreign key when the primary key is updated: * *
  11. DELETE_RULE short {@code =>} What happens to * the foreign key when primary is deleted. * *
  12. FK_NAME String {@code =>} foreign key name (may be null) *
  13. PK_NAME String {@code =>} primary key name (may be null) *
  14. DEFERRABILITY short {@code =>} can the evaluation of foreign key * constraints be deferred until commit * *
* @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schema a schema name; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param table a table name; must match the table name as it is stored * in the database * @return ResultSet - each row is a primary key column description * @exception SQLException if a database access error occurs * @see #getExportedKeys */ // @ts-ignore getImportedKeys(catalog: java.lang.String | string, schema: java.lang.String | string, table: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the foreign key columns that reference the * given table's primary key columns (the foreign keys exported by a * table). They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, * FKTABLE_NAME, and KEY_SEQ. *

Each foreign key column description has the following columns: *

    *
  1. PKTABLE_CAT String {@code =>} primary key table catalog (may be null) *
  2. PKTABLE_SCHEM String {@code =>} primary key table schema (may be null) *
  3. PKTABLE_NAME String {@code =>} primary key table name *
  4. PKCOLUMN_NAME String {@code =>} primary key column name *
  5. FKTABLE_CAT String {@code =>} foreign key table catalog (may be null) * being exported (may be null) *
  6. FKTABLE_SCHEM String {@code =>} foreign key table schema (may be null) * being exported (may be null) *
  7. FKTABLE_NAME String {@code =>} foreign key table name * being exported *
  8. FKCOLUMN_NAME String {@code =>} foreign key column name * being exported *
  9. KEY_SEQ short {@code =>} sequence number within foreign key( a value * of 1 represents the first column of the foreign key, a value of 2 would * represent the second column within the foreign key). *
  10. UPDATE_RULE short {@code =>} What happens to * foreign key when primary is updated: * *
  11. DELETE_RULE short {@code =>} What happens to * the foreign key when primary is deleted. * *
  12. FK_NAME String {@code =>} foreign key name (may be null) *
  13. PK_NAME String {@code =>} primary key name (may be null) *
  14. DEFERRABILITY short {@code =>} can the evaluation of foreign key * constraints be deferred until commit * *
* @param catalog a catalog name; must match the catalog name as it * is stored in this database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schema a schema name; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param table a table name; must match the table name as it is stored * in this database * @return a ResultSet object in which each row is a * foreign key column description * @exception SQLException if a database access error occurs * @see #getImportedKeys */ // @ts-ignore getExportedKeys(catalog: java.lang.String | string, schema: java.lang.String | string, table: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the foreign key columns in the given foreign key * table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table). * The number of columns returned from the parent table must match the number of * columns that make up the foreign key. They * are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and * KEY_SEQ. *

Each foreign key column description has the following columns: *

    *
  1. PKTABLE_CAT String {@code =>} parent key table catalog (may be null) *
  2. PKTABLE_SCHEM String {@code =>} parent key table schema (may be null) *
  3. PKTABLE_NAME String {@code =>} parent key table name *
  4. PKCOLUMN_NAME String {@code =>} parent key column name *
  5. FKTABLE_CAT String {@code =>} foreign key table catalog (may be null) * being exported (may be null) *
  6. FKTABLE_SCHEM String {@code =>} foreign key table schema (may be null) * being exported (may be null) *
  7. FKTABLE_NAME String {@code =>} foreign key table name * being exported *
  8. FKCOLUMN_NAME String {@code =>} foreign key column name * being exported *
  9. KEY_SEQ short {@code =>} sequence number within foreign key( a value * of 1 represents the first column of the foreign key, a value of 2 would * represent the second column within the foreign key). *
  10. UPDATE_RULE short {@code =>} What happens to * foreign key when parent key is updated: * *
  11. DELETE_RULE short {@code =>} What happens to * the foreign key when parent key is deleted. * *
  12. FK_NAME String {@code =>} foreign key name (may be null) *
  13. PK_NAME String {@code =>} parent key name (may be null) *
  14. DEFERRABILITY short {@code =>} can the evaluation of foreign key * constraints be deferred until commit * *
* @param parentCatalog a catalog name; must match the catalog name * as it is stored in the database; "" retrieves those without a * catalog; null means drop catalog name from the selection criteria * @param parentSchema a schema name; must match the schema name as * it is stored in the database; "" retrieves those without a schema; * null means drop schema name from the selection criteria * @param parentTable the name of the table that exports the key; must match * the table name as it is stored in the database * @param foreignCatalog a catalog name; must match the catalog name as * it is stored in the database; "" retrieves those without a * catalog; null means drop catalog name from the selection criteria * @param foreignSchema a schema name; must match the schema name as it * is stored in the database; "" retrieves those without a schema; * null means drop schema name from the selection criteria * @param foreignTable the name of the table that imports the key; must match * the table name as it is stored in the database * @return ResultSet - each row is a foreign key column description * @exception SQLException if a database access error occurs * @see #getImportedKeys */ // @ts-ignore getCrossReference(parentCatalog: java.lang.String | string, parentSchema: java.lang.String | string, parentTable: java.lang.String | string, foreignCatalog: java.lang.String | string, foreignSchema: java.lang.String | string, foreignTable: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of all the data types supported by * this database. They are ordered by DATA_TYPE and then by how * closely the data type maps to the corresponding JDBC SQL type. *

If the database supports SQL distinct types, then getTypeInfo() will return * a single row with a TYPE_NAME of DISTINCT and a DATA_TYPE of Types.DISTINCT. * If the database supports SQL structured types, then getTypeInfo() will return * a single row with a TYPE_NAME of STRUCT and a DATA_TYPE of Types.STRUCT. *

If SQL distinct or structured types are supported, then information on the * individual types may be obtained from the getUDTs() method. *

Each type description has the following columns: *

    *
  1. TYPE_NAME String {@code =>} Type name *
  2. DATA_TYPE int {@code =>} SQL data type from java.sql.Types *
  3. PRECISION int {@code =>} maximum precision *
  4. LITERAL_PREFIX String {@code =>} prefix used to quote a literal * (may be null) *
  5. LITERAL_SUFFIX String {@code =>} suffix used to quote a literal * (may be null) *
  6. CREATE_PARAMS String {@code =>} parameters used in creating * the type (may be null) *
  7. NULLABLE short {@code =>} can you use NULL for this type. * *
  8. CASE_SENSITIVE boolean{@code =>} is it case sensitive. *
  9. SEARCHABLE short {@code =>} can you use "WHERE" based on this type: * *
  10. UNSIGNED_ATTRIBUTE boolean {@code =>} is it unsigned. *
  11. FIXED_PREC_SCALE boolean {@code =>} can it be a money value. *
  12. AUTO_INCREMENT boolean {@code =>} can it be used for an * auto-increment value. *
  13. LOCAL_TYPE_NAME String {@code =>} localized version of type name * (may be null) *
  14. MINIMUM_SCALE short {@code =>} minimum scale supported *
  15. MAXIMUM_SCALE short {@code =>} maximum scale supported *
  16. SQL_DATA_TYPE int {@code =>} unused *
  17. SQL_DATETIME_SUB int {@code =>} unused *
  18. NUM_PREC_RADIX int {@code =>} usually 2 or 10 *
*

The PRECISION column represents the maximum column size that the server supports for the given datatype. * For numeric data, this is the maximum precision. For character data, this is the length in characters. * For datetime datatypes, this is the length in characters of the String representation (assuming the * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, * this is the length in bytes. Null is returned for data types where the * column size is not applicable. * @return a ResultSet object in which each row is an SQL * type description * @exception SQLException if a database access error occurs */ // @ts-ignore getTypeInfo(): java.sql.ResultSet /** * Retrieves a description of the given table's indices and statistics. They are * ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION. *

Each index column description has the following columns: *

    *
  1. TABLE_CAT String {@code =>} table catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} table schema (may be null) *
  3. TABLE_NAME String {@code =>} table name *
  4. NON_UNIQUE boolean {@code =>} Can index values be non-unique. * false when TYPE is tableIndexStatistic *
  5. INDEX_QUALIFIER String {@code =>} index catalog (may be null); * null when TYPE is tableIndexStatistic *
  6. INDEX_NAME String {@code =>} index name; null when TYPE is * tableIndexStatistic *
  7. TYPE short {@code =>} index type: * *
  8. ORDINAL_POSITION short {@code =>} column sequence number * within index; zero when TYPE is tableIndexStatistic *
  9. COLUMN_NAME String {@code =>} column name; null when TYPE is * tableIndexStatistic *
  10. ASC_OR_DESC String {@code =>} column sort sequence, "A" {@code =>} ascending, * "D" {@code =>} descending, may be null if sort sequence is not supported; * null when TYPE is tableIndexStatistic *
  11. CARDINALITY long {@code =>} 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 {@code =>} 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 {@code =>} Filter condition, if any. * (may be null) *
* @param catalog a catalog name; must match the catalog name as it * is stored in this database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schema a schema name; must match the schema name * as it is stored in this database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param table a table name; must match the table name as it is stored * in this database * @param unique when true, return only indices for unique values; * when false, return indices regardless of whether unique or not * @param approximate when true, result is allowed to reflect approximate * or out of data values; when false, results are requested to be * accurate * @return ResultSet - each row is an index column description * @exception SQLException if a database access error occurs */ // @ts-ignore getIndexInfo(catalog: java.lang.String | string, schema: java.lang.String | string, table: java.lang.String | string, unique: boolean, approximate: boolean): java.sql.ResultSet /** * Retrieves whether this database supports the given result set type. * @param type defined in java.sql.ResultSet * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @see Connection * @since 1.2 */ // @ts-ignore supportsResultSetType(type: number /*int*/): boolean /** * Retrieves whether this database supports the given concurrency type * in combination with the given result set type. * @param type defined in java.sql.ResultSet * @param concurrency type defined in java.sql.ResultSet * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @see Connection * @since 1.2 */ // @ts-ignore supportsResultSetConcurrency(type: number /*int*/, concurrency: number /*int*/): boolean /** * Retrieves whether for the given type of ResultSet object, * the result set's own updates are visible. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if updates are visible for the given result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore ownUpdatesAreVisible(type: number /*int*/): boolean /** * Retrieves whether a result set's own deletes are visible. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if deletes are visible for the given result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore ownDeletesAreVisible(type: number /*int*/): boolean /** * Retrieves whether a result set's own inserts are visible. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if inserts are visible for the given result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore ownInsertsAreVisible(type: number /*int*/): boolean /** * Retrieves whether updates made by others are visible. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if updates made by others * are visible for the given result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore othersUpdatesAreVisible(type: number /*int*/): boolean /** * Retrieves whether deletes made by others are visible. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if deletes made by others * are visible for the given result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore othersDeletesAreVisible(type: number /*int*/): boolean /** * Retrieves whether inserts made by others are visible. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if inserts made by others * are visible for the given result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore othersInsertsAreVisible(type: number /*int*/): boolean /** * Retrieves whether or not a visible row update can be detected by * calling the method ResultSet.rowUpdated. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if changes are detected by the result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore updatesAreDetected(type: number /*int*/): boolean /** * Retrieves whether or not a visible row delete can be detected by * calling the method ResultSet.rowDeleted. If the method * deletesAreDetected returns false, it means that * deleted rows are removed from the result set. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if deletes are detected by the given result set type; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore deletesAreDetected(type: number /*int*/): boolean /** * Retrieves whether or not a visible row insert can be detected * by calling the method ResultSet.rowInserted. * @param type the ResultSet type; one of * ResultSet.TYPE_FORWARD_ONLY, * ResultSet.TYPE_SCROLL_INSENSITIVE, or * ResultSet.TYPE_SCROLL_SENSITIVE * @return true if changes are detected by the specified result * set type; false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore insertsAreDetected(type: number /*int*/): boolean /** * Retrieves whether this database supports batch updates. * @return true if this database supports batch updates; * false otherwise * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore supportsBatchUpdates(): boolean /** * Retrieves a description of the user-defined types (UDTs) defined * in a particular schema. Schema-specific UDTs may have type * JAVA_OBJECT, STRUCT, * or DISTINCT. *

Only types matching the catalog, schema, type name and type * criteria are returned. They are ordered by DATA_TYPE, * TYPE_CAT, 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 {@code =>} the type's catalog (may be null) *
  2. TYPE_SCHEM String {@code =>} type's schema (may be null) *
  3. TYPE_NAME String {@code =>} type name *
  4. CLASS_NAME String {@code =>} Java class name *
  5. DATA_TYPE int {@code =>} type value defined in java.sql.Types. * One of JAVA_OBJECT, STRUCT, or DISTINCT *
  6. REMARKS String {@code =>} explanatory comment on the type *
  7. BASE_TYPE short {@code =>} type code of the source type of a * DISTINCT type or the type that implements the user-generated * reference type of the SELF_REFERENCING_COLUMN of a structured * type as defined in java.sql.Types (null if DATA_TYPE is not * DISTINCT or not STRUCT with REFERENCE_GENERATION = USER_DEFINED) *
*

Note: If the driver does not support UDTs, an empty * result set is returned. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema pattern name; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param typeNamePattern a type name pattern; must match the type name * as it is stored in the database; may be a fully qualified name * @param types a list of user-defined types (JAVA_OBJECT, * STRUCT, or DISTINCT) to include; null returns all types * @return ResultSet object in which each row describes a UDT * @exception SQLException if a database access error occurs * @see #getSearchStringEscape * @since 1.2 */ // @ts-ignore getUDTs(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, typeNamePattern: java.lang.String | string, types: number /*int*/[]): java.sql.ResultSet /** * Retrieves the connection that produced this metadata object. *

* @return the connection that produced this metadata object * @exception SQLException if a database access error occurs * @since 1.2 */ // @ts-ignore getConnection(): java.sql.Connection /** * Retrieves whether this database supports savepoints. * @return true if savepoints are supported; * false otherwise * @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore supportsSavepoints(): boolean /** * Retrieves whether this database supports named parameters to callable * statements. * @return true if named parameters are supported; * false otherwise * @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore supportsNamedParameters(): boolean /** * Retrieves whether it is possible to have multiple ResultSet objects * returned from a CallableStatement object * simultaneously. * @return true if a CallableStatement object * can return multiple ResultSet objects * simultaneously; false otherwise * @exception SQLException if a datanase access error occurs * @since 1.4 */ // @ts-ignore supportsMultipleOpenResults(): boolean /** * Retrieves whether auto-generated keys can be retrieved after * a statement has been executed * @return true if auto-generated keys can be retrieved * after a statement has executed; false otherwise *

If true is returned, the JDBC driver must support the * returning of auto-generated keys for at least SQL INSERT statements *

* @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore supportsGetGeneratedKeys(): boolean /** * Retrieves a description of the user-defined type (UDT) hierarchies defined in a * particular schema in this database. Only the immediate super type/ * sub type relationship is modeled. *

* 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 {@code =>} the UDT's catalog (may be null) *
  2. TYPE_SCHEM String {@code =>} UDT's schema (may be null) *
  3. TYPE_NAME String {@code =>} type name of the UDT *
  4. SUPERTYPE_CAT String {@code =>} the direct super type's catalog * (may be null) *
  5. SUPERTYPE_SCHEM String {@code =>} the direct super type's schema * (may be null) *
  6. SUPERTYPE_NAME String {@code =>} the direct super type's name *
*

Note: If the driver does not support type hierarchies, an * empty result set is returned. * @param catalog a catalog name; "" retrieves those without a catalog; * null means drop catalog name from the selection criteria * @param schemaPattern a schema name pattern; "" retrieves those * without a schema * @param typeNamePattern a UDT name pattern; may be a fully-qualified * name * @return a ResultSet object in which a row gives information * about the designated UDT * @throws SQLException if a database access error occurs * @see #getSearchStringEscape * @since 1.4 */ // @ts-ignore getSuperTypes(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, typeNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the table hierarchies defined in a particular * schema in this database. *

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 {@code =>} the type's catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} type's schema (may be null) *
  3. TABLE_NAME String {@code =>} type name *
  4. SUPERTABLE_NAME String {@code =>} the direct super type's name *
*

Note: If the driver does not support type hierarchies, an * empty result set is returned. * @param catalog a catalog name; "" retrieves those without a catalog; * null means drop catalog name from the selection criteria * @param schemaPattern a schema name pattern; "" retrieves those * without a schema * @param tableNamePattern a table name pattern; may be a fully-qualified * name * @return a ResultSet object in which each row is a type description * @throws SQLException if a database access error occurs * @see #getSearchStringEscape * @since 1.4 */ // @ts-ignore getSuperTables(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, tableNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the given attribute of the given type * for a user-defined type (UDT) that is available in the given schema * and catalog. *

* Descriptions are returned only for attributes of UDTs matching the * catalog, schema, type, and attribute name criteria. They are ordered by * TYPE_CAT, 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 {@code =>} type catalog (may be null) *
  2. TYPE_SCHEM String {@code =>} type schema (may be null) *
  3. TYPE_NAME String {@code =>} type name *
  4. ATTR_NAME String {@code =>} attribute name *
  5. DATA_TYPE int {@code =>} attribute type SQL type from java.sql.Types *
  6. ATTR_TYPE_NAME String {@code =>} 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 {@code =>} 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 {@code =>} the number of fractional digits. Null is returned for data types where * DECIMAL_DIGITS is not applicable. *
  9. NUM_PREC_RADIX int {@code =>} Radix (typically either 10 or 2) *
  10. NULLABLE int {@code =>} whether NULL is allowed * *
  11. REMARKS String {@code =>} comment describing column (may be null) *
  12. ATTR_DEF String {@code =>} default value (may be null) *
  13. SQL_DATA_TYPE int {@code =>} unused *
  14. SQL_DATETIME_SUB int {@code =>} unused *
  15. CHAR_OCTET_LENGTH int {@code =>} for char types the * maximum number of bytes in the column *
  16. ORDINAL_POSITION int {@code =>} index of the attribute in the UDT * (starting at 1) *
  17. IS_NULLABLE String {@code =>} ISO rules are used to determine * the nullability for a attribute. * *
  18. SCOPE_CATALOG String {@code =>} catalog of table that is the * scope of a reference attribute (null if DATA_TYPE isn't REF) *
  19. SCOPE_SCHEMA String {@code =>} schema of table that is the * scope of a reference attribute (null if DATA_TYPE isn't REF) *
  20. SCOPE_TABLE String {@code =>} table name that is the scope of a * reference attribute (null if the DATA_TYPE isn't REF) *
  21. SOURCE_DATA_TYPE short {@code =>} 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) *
* @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param typeNamePattern a type name pattern; must match the * type name as it is stored in the database * @param attributeNamePattern an attribute name pattern; must match the attribute * name as it is declared in the database * @return a ResultSet object in which each row is an * attribute description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape * @since 1.4 */ // @ts-ignore getAttributes(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, typeNamePattern: java.lang.String | string, attributeNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves whether this database supports the given result set holdability. * @param holdability one of the following constants: * ResultSet.HOLD_CURSORS_OVER_COMMIT or * ResultSet.CLOSE_CURSORS_AT_COMMIT * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @see Connection * @since 1.4 */ // @ts-ignore supportsResultSetHoldability(holdability: number /*int*/): boolean /** * Retrieves this database's default holdability for ResultSet * objects. * @return the default holdability; either * ResultSet.HOLD_CURSORS_OVER_COMMIT or * ResultSet.CLOSE_CURSORS_AT_COMMIT * @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore getResultSetHoldability(): number /*int*/ /** * Retrieves the major version number of the underlying database. * @return the underlying database's major version * @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore getDatabaseMajorVersion(): number /*int*/ /** * Retrieves the minor version number of the underlying database. * @return underlying database's minor version * @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore getDatabaseMinorVersion(): number /*int*/ /** * Retrieves the major JDBC version number for this * driver. * @return JDBC version major number * @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore getJDBCMajorVersion(): number /*int*/ /** * Retrieves the minor JDBC version number for this * driver. * @return JDBC version minor number * @exception SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore getJDBCMinorVersion(): number /*int*/ /** * Indicates whether the SQLSTATE returned by SQLException.getSQLState * is X/Open (now known as Open Group) SQL CLI or SQL:2003. * @return the type of SQLSTATE; one of: * sqlStateXOpen or * sqlStateSQL * @throws SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore getSQLStateType(): number /*int*/ /** * Indicates whether updates made to a LOB are made on a copy or directly * to the LOB. * @return true if updates are made to a copy of the LOB; * false if updates are made directly to the LOB * @throws SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore locatorsUpdateCopy(): boolean /** * Retrieves whether this database supports statement pooling. * @return true if so; false otherwise * @throws SQLException if a database access error occurs * @since 1.4 */ // @ts-ignore supportsStatementPooling(): boolean /** * Indicates whether or not this data source supports the SQL ROWID type, * and if so the lifetime for which a RowId object remains valid. *

* The returned int values have the following relationship: * 

{@code
             * ROWID_UNSUPPORTED < ROWID_VALID_OTHER < ROWID_VALID_TRANSACTION
             * < ROWID_VALID_SESSION < ROWID_VALID_FOREVER
             * }
* so conditional logic such as * 
{@code
             * if (metadata.getRowIdLifetime() > DatabaseMetaData.ROWID_VALID_TRANSACTION)
             * }
* can be used. Valid Forever means valid across all Sessions, and valid for * a Session means valid across all its contained Transactions. * @return the status indicating the lifetime of a RowId * @throws SQLException if a database access error occurs * @since 1.6 */ // @ts-ignore getRowIdLifetime(): java.sql.RowIdLifetime /** * Retrieves the schema names available in this database. The results * are ordered by TABLE_CATALOG and * TABLE_SCHEM. *

The schema columns are: *

    *
  1. TABLE_SCHEM String {@code =>} schema name *
  2. TABLE_CATALOG String {@code =>} catalog name (may be null) *
* @param catalog a catalog name; must match the catalog name as it is stored * in the database;"" retrieves those without a catalog; null means catalog * name should not be used to narrow down the search. * @param schemaPattern a schema name; must match the schema name as it is * stored in the database; null means * schema name should not be used to narrow down the search. * @return a ResultSet object in which each row is a * schema description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape * @since 1.6 */ // @ts-ignore getSchemas(catalog: java.lang.String | string, schemaPattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves whether this database supports invoking user-defined or vendor functions * using the stored procedure escape syntax. * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @since 1.6 */ // @ts-ignore supportsStoredFunctionsUsingCallSyntax(): boolean /** * Retrieves whether a SQLException while autoCommit is true indicates * that all open ResultSets are closed, even ones that are holdable. When a SQLException occurs while * autocommit is true, it is vendor specific whether the JDBC driver responds with a commit operation, a * rollback operation, or by doing neither a commit nor a rollback. A potential result of this difference * is in whether or not holdable ResultSets are closed. * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @since 1.6 */ // @ts-ignore autoCommitFailureClosesAllResultSets(): boolean /** * Retrieves a list of the client info properties * that the driver supports. The result set contains the following columns *
    *
  1. NAME String{@code =>} The name of the client info property
    *
  2. MAX_LEN int{@code =>} The maximum length of the value for the property
    *
  3. DEFAULT_VALUE String{@code =>} The default value of the property
    *
  4. DESCRIPTION String{@code =>} A description of the property. This will typically * contain information as to where this property is * stored in the database. *
*

* The ResultSet is sorted by the NAME column *

* @return A ResultSet object; each row is a supported client info * property *

* @exception SQLException if a database access error occurs *

* @since 1.6 */ // @ts-ignore getClientInfoProperties(): java.sql.ResultSet /** * Retrieves a description of the system and user functions available * in the given catalog. *

* Only system and user function descriptions matching the schema and * function name criteria are returned. They are ordered by * FUNCTION_CAT, FUNCTION_SCHEM, * FUNCTION_NAME and * SPECIFIC_ NAME. *

Each function description has the the following columns: *

    *
  1. FUNCTION_CAT String {@code =>} function catalog (may be null) *
  2. FUNCTION_SCHEM String {@code =>} function schema (may be null) *
  3. FUNCTION_NAME String {@code =>} function name. This is the name * used to invoke the function *
  4. REMARKS String {@code =>} explanatory comment on the function *
  5. FUNCTION_TYPE short {@code =>} kind of function: * *
  6. SPECIFIC_NAME String {@code =>} the name which uniquely identifies * this function within its schema. This is a user specified, or DBMS * generated, name that may be different then the FUNCTION_NAME * for example with overload functions *
*

* A user may not have permission to execute any of the functions that are * returned by getFunctions * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param functionNamePattern a function name pattern; must match the * function name as it is stored in the database * @return ResultSet - each row is a function description * @exception SQLException if a database access error occurs * @see #getSearchStringEscape * @since 1.6 */ // @ts-ignore getFunctions(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, functionNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the given catalog's system or user * function parameters and return type. *

Only descriptions matching the schema, function and * parameter name criteria are returned. They are ordered by * FUNCTION_CAT, FUNCTION_SCHEM, * FUNCTION_NAME and * SPECIFIC_ 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 ResultSet * is a parameter description, column description or * return type description with the following fields: *

    *
  1. FUNCTION_CAT String {@code =>} function catalog (may be null) *
  2. FUNCTION_SCHEM String {@code =>} function schema (may be null) *
  3. FUNCTION_NAME String {@code =>} function name. This is the name * used to invoke the function *
  4. COLUMN_NAME String {@code =>} column/parameter name *
  5. COLUMN_TYPE Short {@code =>} kind of column/parameter: * *
  6. DATA_TYPE int {@code =>} SQL type from java.sql.Types *
  7. TYPE_NAME String {@code =>} SQL type name, for a UDT type the * type name is fully qualified *
  8. PRECISION int {@code =>} precision *
  9. LENGTH int {@code =>} length in bytes of data *
  10. SCALE short {@code =>} scale - null is returned for data types where * SCALE is not applicable. *
  11. RADIX short {@code =>} radix *
  12. NULLABLE short {@code =>} can it contain NULL. * *
  13. REMARKS String {@code =>} comment describing column/parameter *
  14. CHAR_OCTET_LENGTH int {@code =>} the maximum length of binary * and character based parameters or columns. For any other datatype the returned value * is a NULL *
  15. ORDINAL_POSITION int {@code =>} the ordinal position, starting * from 1, for the input and output parameters. A value of 0 * is returned if this row describes the function's return value. * For result set columns, it is the * ordinal position of the column in the result set starting from 1. *
  16. IS_NULLABLE String {@code =>} ISO rules are used to determine * the nullability for a parameter or column. * *
  17. SPECIFIC_NAME String {@code =>} the name which uniquely identifies * this function within its schema. This is a user specified, or DBMS * generated, name that may be different then the FUNCTION_NAME * for example with overload functions *
*

The PRECISION column represents the specified column size for the given * parameter or column. * For numeric data, this is the maximum precision. For character data, this is the length in characters. * For datetime datatypes, this is the length in characters of the String representation (assuming the * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, * this is the length in bytes. Null is returned for data types where the * column size is not applicable. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param functionNamePattern a procedure name pattern; must match the * function name as it is stored in the database * @param columnNamePattern a parameter name pattern; must match the * parameter or column name as it is stored in the database * @return ResultSet - each row describes a * user function parameter, column or return type * @exception SQLException if a database access error occurs * @see #getSearchStringEscape * @since 1.6 */ // @ts-ignore getFunctionColumns(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, functionNamePattern: java.lang.String | string, columnNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves a description of the pseudo or hidden columns available * in a given table within the specified catalog and schema. * Pseudo or hidden columns may not always be stored within * a table and are not visible in a ResultSet unless they are * specified in the query's outermost SELECT list. Pseudo or hidden * columns may not necessarily be able to be modified. If there are * no pseudo or hidden columns, an empty ResultSet is returned. *

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

Each column description has the following columns: *

    *
  1. TABLE_CAT String {@code =>} table catalog (may be null) *
  2. TABLE_SCHEM String {@code =>} table schema (may be null) *
  3. TABLE_NAME String {@code =>} table name *
  4. COLUMN_NAME String {@code =>} column name *
  5. DATA_TYPE int {@code =>} SQL type from java.sql.Types *
  6. COLUMN_SIZE int {@code =>} column size. *
  7. DECIMAL_DIGITS int {@code =>} the number of fractional digits. Null is returned for data types where * DECIMAL_DIGITS is not applicable. *
  8. NUM_PREC_RADIX int {@code =>} Radix (typically either 10 or 2) *
  9. COLUMN_USAGE String {@code =>} The allowed usage for the column. The * value returned will correspond to the enum name returned by {@link PseudoColumnUsage#name PseudoColumnUsage.name()} *
  10. REMARKS String {@code =>} comment describing column (may be null) *
  11. CHAR_OCTET_LENGTH int {@code =>} for char types the * maximum number of bytes in the column *
  12. IS_NULLABLE String {@code =>} ISO rules are used to determine the nullability for a column. * *
*

The COLUMN_SIZE column specifies the column size for the given column. * For numeric data, this is the maximum precision. For character data, this is the length in characters. * For datetime datatypes, this is the length in characters of the String representation (assuming the * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, * this is the length in bytes. Null is returned for data types where the * column size is not applicable. * @param catalog a catalog name; must match the catalog name as it * is stored in the database; "" retrieves those without a catalog; * null means that the catalog name should not be used to narrow * the search * @param schemaPattern a schema name pattern; must match the schema name * as it is stored in the database; "" retrieves those without a schema; * null means that the schema name should not be used to narrow * the search * @param tableNamePattern a table name pattern; must match the * table name as it is stored in the database * @param columnNamePattern a column name pattern; must match the column * name as it is stored in the database * @return ResultSet - each row is a column description * @exception SQLException if a database access error occurs * @see PseudoColumnUsage * @since 1.7 */ // @ts-ignore getPseudoColumns(catalog: java.lang.String | string, schemaPattern: java.lang.String | string, tableNamePattern: java.lang.String | string, columnNamePattern: java.lang.String | string): java.sql.ResultSet /** * Retrieves whether a generated key will always be returned if the column * name(s) or index(es) specified for the auto generated key column(s) * are valid and the statement succeeds. The key that is returned may or * may not be based on the column(s) for the auto generated key. * Consult your JDBC driver documentation for additional details. * @return true if so; false otherwise * @exception SQLException if a database access error occurs * @since 1.7 */ // @ts-ignore generatedKeyAlwaysReturned(): boolean /** * Retrieves the maximum number of bytes this database allows for * the logical size for a {@code LOB}. *

* The default implementation will return {@code 0} * @return the maximum number of bytes allowed; a result of zero * means that there is no limit or the limit is not known * @exception SQLException if a database access error occurs * @since 1.8 */ // @ts-ignore getMaxLogicalLobSize(): number /*long*/ /** * Retrieves whether this database supports REF CURSOR. *

* The default implementation will return {@code false} * @return {#code true} if this database supports REF CURSOR; * {@code false} otherwise * @exception SQLException if a database access error occurs * @since 1.8 */ // @ts-ignore supportsRefCursors(): boolean } } }