Members

The members of Java.Sql.IDatabaseMetaData are listed below.

Public Properties

[read-only]	Catalogs	IResultSet. Returns the set of catalog names available in this database.
[read-only]	CatalogSeparator	string. Returns the separator that this database uses between a catalog name and table name.
[read-only]	CatalogTerm	string. Returns the term that the database vendor prefers term for "catalog".
[read-only]	ClientInfoProperties	IResultSet. Returns a list of the client info properties of the driver.
[read-only]	Connection	IConnection. Returns the database connection that created this metadata.
[read-only]	DatabaseMajorVersion	int. Returns the major version number of the database software.
[read-only]	DatabaseMinorVersion	int. Returns the minor version number of the database software.
[read-only]	DatabaseProductName	string. Returns the name of the database software.
[read-only]	DatabaseProductVersion	string. Returns the version number of this database software.
[read-only]	DefaultTransactionIsolation	int. Returns the default transaction isolation level for this database.
[read-only]	DriverMajorVersion	int. Returns the JDBC driver's major version number.
[read-only]	DriverMinorVersion	int. Returns the JDBC driver's minor version number.
[read-only]	DriverName	string. Returns the name of this JDBC driver.
[read-only]	DriverVersion	string. Returns the version number of this JDBC driver.
[read-only]	ExtraNameCharacters	string. Returns a string of characters that may be used in unquoted identifier names.
[read-only]	IdentifierQuoteString	string. Returns the string used to quote SQL identifiers.
[read-only]	IsCatalogAtStart	bool. Determine whether a fully qualified table name is prefixed or suffixed to a fully qualified table name.
[read-only]	IsReadOnly	bool. Determines whether the database is in read-only mode.
[read-only]	JDBCMajorVersion	int. Returns this driver's major JDBC version number.
[read-only]	JDBCMinorVersion	int. Returns the minor JDBC version number for this driver.
[read-only]	MaxBinaryLiteralLength	int. Get the maximum number of hex characters in an in-line binary literal for this database.
[read-only]	MaxCatalogNameLength	int. Returns the maximum size of a catalog name in this database.
[read-only]	MaxCharLiteralLength	int. Returns the maximum size for a character literal in this database.
[read-only]	MaxColumnNameLength	int. Returns the maximum size for a Column name for this database.
[read-only]	MaxColumnsInGroupBy	int. Get the maximum number of columns in a `GROUP BY` clause for this database.
[read-only]	MaxColumnsInIndex	int. Returns the maximum number of columns in an Index for this database.
[read-only]	MaxColumnsInOrderBy	int. Returns the maximum number of columns in an `ORDER BY` clause for this database.
[read-only]	MaxColumnsInSelect	int. Returns the maximum number of columns in a `SELECT` list for this database.
[read-only]	MaxColumnsInTable	int. Returns the maximum number of columns in a table for this database.
[read-only]	MaxConnections	int. Returns the database's maximum number of concurrent connections.
[read-only]	MaxCursorNameLength	int. Returns the maximum length of a cursor name for this database.
[read-only]	MaxIndexLength	int. Returns the maximum length in bytes for an Index for this database.
[read-only]	MaxProcedureNameLength	int. Returns the maximum number of characters for a procedure name in this database.
[read-only]	MaxRowSize	int. Returns the maximum number of bytes within a single row for this database.
[read-only]	MaxSchemaNameLength	int. Returns the maximum number of characters in a schema name for this database.
[read-only]	MaxStatementLength	int. Returns the maximum number of characters in an SQL statement for this database.
[read-only]	MaxStatements	int. Get the maximum number of simultaneously open active statements for this database.
[read-only]	MaxTableNameLength	int. Returns the maximum size for a table name in the database.
[read-only]	MaxTablesInSelect	int. Returns the maximum number of tables permitted in a `SELECT` statement for the database.
[read-only]	MaxUserNameLength	int. Returns the maximum number of characters in a user name for the database.
[read-only]	NumericFunctions	string. Returns a list of the math functions available with this database.
[read-only]	ProcedureTerm	string. Returns the database vendor's preferred name for "procedure".
[read-only]	ResultSetHoldability	int. Returns the result set's default holdability.
[read-only]	RowIdLifetime	RowIdLifetime. Returns the lifetime for which a RowId object remains valid if this data source supports the SQL ROWID type
[read-only]	Schemas	IResultSet. Returns a list of the schema names in the database.
[read-only]	SchemaTerm	string. Returns the database vendor's preferred term for "schema".
[read-only]	SearchStringEscape	string. Returns the string that is used to escape wildcard characters.
[read-only]	SQLKeywords	string. Returns a list of all the SQL keywords that are NOT also SQL92 keywords for the database.
[read-only]	SQLStateType	int. States the type of `SQLState` value returned by `SQLException.getSQLState`.
[read-only]	StringFunctions	string. Returns a list of string functions available with the database.
[read-only]	SystemFunctions	string. Returns a list of system functions available with the database.
[read-only]	TableTypes	IResultSet. Returns a list of table types supported by the database.
[read-only]	TimeDateFunctions	string. Returns a list of time and date functions available for the database.
[read-only]	TypeInfo	IResultSet. Get a list of the standard SQL types supported by this database.
[read-only]	URL	string. Returns the URL for this database.
[read-only]	UserName	string. Determine the user name as known by the database.

Public Methods

	AllProceduresAreCallable() : bool Returns whether all procedures returned by `DatabaseMetaData.getProcedures(java.lang.String, java.lang.String, java.lang.String)` can be called by the current user.
	AllTablesAreSelectable() : bool Returns whether all the tables returned by `getTables` can be used by the current user in a `SELECT` statement.
	AutoCommitFailureClosesAllResultSets() : bool Determine if a SQLException while autoCommit is true indicates that all open ResultSets are closed, even ones that are holdable
	DataDefinitionCausesTransactionCommit() : bool Returns whether a data definition statement in a transaction forces a `commit` of the transaction.
	DataDefinitionIgnoredInTransactions() : bool Returns whether the database ignores data definition statements within a transaction.
	DeletesAreDetected(int) : bool Returns whether a visible row delete can be detected by calling `ResultSet.rowDeleted()`.
	DoesMaxRowSizeIncludeBlobs() : bool Returns whether the return value of `getMaxRowSize` includes the SQL data types `LONGVARCHAR` and `LONGVARBINARY`.
	GeneratedKeyAlwaysReturned() : bool Documentation for this section has not yet been entered.
	GetAttributes(string, string, string, string) : IResultSet Returns a `ResultSet` describing a subset of the attributes of a specified SQL User Defined Type (UDT) for a specified schema and catalog.
	GetBestRowIdentifier(string, string, string, int, bool) : IResultSet Returns a list of a table's optimal set of columns that uniquely identify the rows.
	GetColumnPrivileges(string, string, string, string) : IResultSet Returns a description of access rights for a table's columns.
	GetColumns(string, string, string, string) : IResultSet Returns a description of table columns available in a specified catalog.
	GetCrossReference(string, string, string, string, string, string) : IResultSet Returns a list of foreign key columns in a given foreign key table that reference the primary key columns of a supplied primary key table.
	GetExportedKeys(string, string, string) : IResultSet Returns a list of the foreign key columns that reference the primary key columns of a specified table (the foreign keys exported by a table).
	GetFunctionColumns(string, string, string, string) : IResultSet Returns a description according to the given catalog's system or user function parameters and return type.
	GetFunctions(string, string, string) : IResultSet Returns a description of the system and user functions available according to the given catalog.
	GetImportedKeys(string, string, string) : IResultSet Returns a list columns in a table that are both primary keys and referenced by the table's foreign key columns (that is, the primary keys imported by a table).
	GetIndexInfo(string, string, string, bool, bool) : IResultSet Returns a list of indices and statistics for a specified table.
	GetPrimaryKeys(string, string, string) : IResultSet Returns a list of the primary key columns of a specified table.
	GetProcedureColumns(string, string, string, string) : IResultSet Returns a list of parameter and result columns for the stored procedures belonging to a specified catalog.
	GetProcedures(string, string, string) : IResultSet Returns a list of the stored procedures available in a specified catalog.
	GetPseudoColumns(string, string, string, string) : IResultSet Documentation for this section has not yet been entered.
	GetSchemas(string, string) : IResultSet Returns the schema names ordered by TABLE_CATALOG and TABLE_SCHEMA.
	GetSuperTables(string, string, string) : IResultSet Returns a listing of the hierarchies of tables in a specified schema in the database.
	GetSuperTypes(string, string, string) : IResultSet Returns the User Defined Type (UDT) hierarchies for a given schema.
	GetTablePrivileges(string, string, string) : IResultSet Returns a description of access rights for each table present in a catalog.
	GetTables(string, string, string, string[]) : IResultSet Returns a description of the tables in a specified catalog.
	GetUDTs(string, string, string, int[]) : IResultSet Returns a description of the User Defined Types (UDTs) defined in a given schema, which includes the types `DISTINCT`, `STRUCT` and `JAVA_OBJECT`.
	GetVersionColumns(string, string, string) : IResultSet Returns which of a table's columns are automatically updated when any value in a row is updated.
	InsertsAreDetected(int) : bool Determines whether a visible row insert can be detected by calling `ResultSet.rowInserted`.
	LocatorsUpdateCopy() : bool Determines whether updates are made to a copy of, or directly on, Large Objects (`LOB`s).
	NullPlusNonNullIsNull() : bool Determines whether the database handles concatenations between `NULL` and non-`NULL` values by producing a `NULL` output.
	NullsAreSortedAtEnd() : bool Determines whether `NULL` values are always sorted to the end of sorted results regardless of requested sort order.
	NullsAreSortedAtStart() : bool Determines whether `NULL` values are always sorted at the start of the sorted list, irrespective of the sort order.
	NullsAreSortedHigh() : bool Determines whether `NULL` values are sorted high - i.e. they are sorted as if they are higher than any other values.
	NullsAreSortedLow() : bool Determines whether `NULL` values are sorted low - i.e. they are sorted as if they are lower than any other values.
	OthersDeletesAreVisible(int) : bool Determines whether deletes made by others are visible, for a specified `ResultSet` type.
	OthersInsertsAreVisible(int) : bool Determines whether inserts made by others are visible, for a specified `ResultSet` type.
	OthersUpdatesAreVisible(int) : bool Determines whether updates made by others are visible, for a specified `ResultSet` type.
	OwnDeletesAreVisible(int) : bool Determines whether a `ResultSet` can see its own deletes, for a specified `ResultSet` type.
	OwnInsertsAreVisible(int) : bool Determines whether a `ResultSet` can see its own inserts, for a specified `ResultSet` type.
	OwnUpdatesAreVisible(int) : bool Determines whether a `ResultSet` can see its own updates, for a specified `ResultSet` type.
	StoresLowerCaseIdentifiers() : bool Determines whether the database treats SQL identifiers that are in mixed case (and unquoted) as case insensitive.
	StoresLowerCaseQuotedIdentifiers() : bool Determines whether the database considers mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
	StoresMixedCaseIdentifiers() : bool Determines whether the database considers mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
	StoresMixedCaseQuotedIdentifiers() : bool Determines whether the database considers identifiers as case insensitive if they are mixed case quoted SQL.
	StoresUpperCaseIdentifiers() : bool Determines whether the database considers mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.
	StoresUpperCaseQuotedIdentifiers() : bool Determines whether the database considers mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
	SupportsAlterTableWithAddColumn() : bool Determines whether the database supports `ALTER TABLE` operation with `ADD COLUMN`.
	SupportsAlterTableWithDropColumn() : bool Determines whether the database supports `ALTER TABLE` operation with `DROP COLUMN`.
	SupportsANSI92EntryLevelSQL() : bool Determines whether the database supports the ANSI92 entry level SQL grammar.
	SupportsANSI92FullSQL() : bool Determines whether the database supports the ANSI92 full SQL grammar.
	SupportsANSI92IntermediateSQL() : bool Determines whether the database supports the ANSI92 intermediate SQL Grammar.
	SupportsBatchUpdates() : bool Determines whether the database supports batch updates.
	SupportsCatalogsInDataManipulation() : bool Determines whether catalog names may be used in data manipulation statements.
	SupportsCatalogsInIndexDefinitions() : bool Determines whether catalog names can be used in index definition statements.
	SupportsCatalogsInPrivilegeDefinitions() : bool Determines whether catalog names can be used in privilege definition statements.
	SupportsCatalogsInProcedureCalls() : bool Determines whether catalog names can be used in procedure call statements.
	SupportsCatalogsInTableDefinitions() : bool Determines whether catalog names may be used in table definition statements.
	SupportsColumnAliasing() : bool Determines whether the database supports column aliasing.
	SupportsConvert() : bool Determines whether the database supports the `CONVERT` operation between SQL types.
	SupportsConvert(int, int) : bool Determines whether the database supports `CONVERT` operation for two supplied SQL types.
	SupportsCoreSQLGrammar() : bool Determines whether the database supports the Core SQL Grammar for ODBC.
	SupportsCorrelatedSubqueries() : bool Determines whether the database supports correlated sub-queries.
	SupportsDataDefinitionAndDataManipulationTransactions() : bool Determines whether the database allows both data definition and data manipulation statements inside a transaction.
	SupportsDataManipulationTransactionsOnly() : bool Determines whether the database only allows data manipulation statements inside a transaction.
	SupportsDifferentTableCorrelationNames() : bool Determines whether table correlation names are required to be different from the names of the tables, when they are supported.
	SupportsExpressionsInOrderBy() : bool Determines whether expressions in `ORDER BY` lists are supported.
	SupportsExtendedSQLGrammar() : bool Determines whether the Extended SQL Grammar for ODBC is supported.
	SupportsFullOuterJoins() : bool Determines whether the database supports full nested outer joins.
	SupportsGetGeneratedKeys() : bool Determines whether auto generated keys can be returned when a statement executes.
	SupportsGroupBy() : bool Determines whether the database supports `GROUP BY` clauses.
	SupportsGroupByBeyondSelect() : bool Determines whether the database supports using a column name in a `GROUP BY` clause not included in the `SELECT` statement as long as all of the columns in the `SELECT` statement are used in the `GROUP BY` clause.
	SupportsGroupByUnrelated() : bool Determines whether the database supports using a column name in a `GROUP BY` clause that is not in the `SELECT` statement.
	SupportsIntegrityEnhancementFacility() : bool Determines whether the database supports SQL Integrity Enhancement Facility.
	SupportsLikeEscapeClause() : bool Determines whether the database supports a `LIKE` escape clause.
	SupportsLimitedOuterJoins() : bool Determines whether the database provides limited support for outer join operations.
	SupportsMinimumSQLGrammar() : bool Determines whether the database supports Minimum SQL Grammar for ODBC.
	SupportsMixedCaseIdentifiers() : bool Determines whether the database treats mixed case unquoted SQL identifiers as case sensitive storing them in mixed case.
	SupportsMixedCaseQuotedIdentifiers() : bool Determines whether the database considers mixed case quoted SQL identifiers as case sensitive, storing them in mixed case.
	SupportsMultipleOpenResults() : bool Determines whether it is possible for a single `CallableStatement` to return multiple `ResultSet`s simultaneously.
	SupportsMultipleResultSets() : bool Determines whether retrieving multiple `ResultSet`s from a single call to the `execute` method is supported.
	SupportsMultipleTransactions() : bool Determines whether multiple simultaneous transactions on different connections are supported.
	SupportsNamedParameters() : bool Determines whether callable statements with named parameters is supported.
	SupportsNonNullableColumns() : bool Determines whether columns in the database can be defined as non-nullable.
	SupportsOpenCursorsAcrossCommit() : bool Determines whether keeping cursors open across commit operations is supported.
	SupportsOpenCursorsAcrossRollback() : bool Determines whether the database can keep cursors open across rollback operations.
	SupportsOpenStatementsAcrossCommit() : bool Determines whether keeping statements open across commit operations is supported.
	SupportsOpenStatementsAcrossRollback() : bool Determines whether keeping statements open across rollback operations is supported.
	SupportsOrderByUnrelated() : bool Determines whether using a column in an `ORDER BY` clause that is not in the `SELECT` statement is supported.
	SupportsOuterJoins() : bool Determines whether outer join operations are supported.
	SupportsPositionedDelete() : bool Determines whether positioned `DELETE` statements are supported.
	SupportsPositionedUpdate() : bool Determines whether positioned `UPDATE` statements are supported.
	SupportsResultSetConcurrency(int, int) : bool Determines whether there is support for a given concurrency style for the given `ResultSet`.
	SupportsResultSetHoldability(int) : bool Determines whether the supplied `ResultSet` holdability mode is supported.
	SupportsResultSetType(int) : bool Determines whether the supplied `ResultSet` type is supported.
	SupportsSavepoints() : bool Determines whether savepoints for transactions are supported.
	SupportsSchemasInDataManipulation() : bool Determines whether a schema name may be used in a data manipulation statement.
	SupportsSchemasInIndexDefinitions() : bool Determines whether a schema name may be used in an index definition statement.
	SupportsSchemasInPrivilegeDefinitions() : bool Determines whether a database schema name can be used in a privilege definition statement.
	SupportsSchemasInProcedureCalls() : bool Determines whether a procedure call statement may be contain in a schema name.
	SupportsSchemasInTableDefinitions() : bool Determines whether a schema name can be used in a table definition statement.
	SupportsSelectForUpdate() : bool Determines whether the `SELECT FOR UPDATE` statement is supported.
	SupportsStatementPooling() : bool Determines whether statement pooling is supported.
	SupportsStoredFunctionsUsingCallSyntax() : bool Determine if this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
	SupportsStoredProcedures() : bool Determines whether stored procedure calls using the stored procedure escape syntax is supported.
	SupportsSubqueriesInComparisons() : bool Determines whether subqueries in comparison expressions are supported.
	SupportsSubqueriesInExists() : bool Determines whether subqueries in `EXISTS` expressions are supported.
	SupportsSubqueriesInIns() : bool Determines whether subqueries in `IN` statements are supported.
	SupportsSubqueriesInQuantifieds() : bool Determines whether subqueries in quantified expressions are supported.
	SupportsTableCorrelationNames() : bool Determines whether the database has table correlation names support.
	SupportsTransactionIsolationLevel(int) : bool Determines whether a specified transaction isolation level is supported.
	SupportsTransactions() : bool Determines whether transactions are supported.
	SupportsUnion() : bool Determines whether the `SQL UNION` operation is supported.
	SupportsUnionAll() : bool Determines whether the `SQL UNION ALL` operation is supported.
	UpdatesAreDetected(int) : bool Determines whether the method `ResultSet.rowUpdated` can detect a visible row update for the specified `ResultSet` type.
	UsesLocalFilePerTable() : bool Determines whether this database uses a file for each table.
	UsesLocalFiles() : bool Determines whether this database uses a local file to store tables.