SQLServerDatabaseMetaData Members

Article
03/16/2009

The following tables list the members that are exposed by the SQLServerDatabaseMetaData class.

Constructors

None.

Fields

None.

Inherited Fields

Name	Description
java.sql.DatabaseMetaData	attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown

java.sql.DatabaseMetaData

attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown

Methods

Name	Description
allProceduresAreCallable	Retrieves whether the current user has permissions to call all the procedures returned by the getProcedures method.
allTablesAreSelectable	Retrieves whether the current user has permissions to use all the tables returned by the getTables method in a SELECT statement.
autoCommitFailureClosesAllResultSets	Indicates whether the JDBC driver closes all the open result sets, including the holdable ones, when an auto-commit is enabled and an exception is raised.
dataDefinitionCausesTransactionCommit	Retrieves whether a data definition statement within a transaction forces the transaction to commit.
dataDefinitionIgnoredInTransactions	Retrieves whether this database ignores a data definition statement within a transaction.
deletesAreDetected	Retrieves whether or not a visible row delete can be detected by calling the rowDeleted method of the SQLServerResultSet class.
doesMaxRowSizeIncludeBlobs	Retrieves whether the return value for the getMaxRowSize method includes the SQL data types LONGVARCHAR and LONGVARBINARY.
getAttributes	Retrieves a description of the given attribute of the given type for a user-defined type that is available in the given schema and catalog.
getBestRowIdentifier	Retrieves a description of the optimal set of columns of a table that uniquely identifies a row.
getCatalogs	Retrieves the catalog names that are available in the connected server.
getCatalogSeparator	Retrieves the String that this database uses as the separator between a catalog and table name.
getCatalogTerm	Retrieves the database vendor's preferred term for "catalog".
getClientInfoProperties	Retrieves a list of the client information properties that the driver supports.
getColumnPrivileges	Retrieves a description of the access rights for the columns in a table.
getColumns	Retrieves a description of the table columns that are available in the specified catalog.
getConnection	Retrieves the connection that produced this metadata object.
getCrossReference	Retrieves a description of the foreign key columns in the given foreign key table that references the primary key columns of the given primary key table.
getDatabaseMajorVersion	Retrieves the major version number of the underlying database.
getDatabaseMinorVersion	Retrieves the minor version number of the underlying database.
getDatabaseProductName	Retrieves the name of this database product.
getDatabaseProductVersion	Retrieves the version number of this database product.
getDefaultTransactionIsolation	Retrieves the default transaction isolation level for this database.
getDriverMajorVersion	Retrieves the major version number of this JDBC driver.
getDriverMinorVersion	Retrieves the minor version number of this JDBC driver.
getDriverName	Retrieves the name of this JDBC driver.
getDriverVersion	Retrieves the version number of this JDBC driver.
getExportedKeys	Retrieves a description of the foreign key columns that reference the given table's primary key columns.
getExtraNameCharacters	Retrieves all the extra characters that can be used in unquoted identifier names, for example, those beyond a-z, A-Z, 0-9, and _.
getFunctions	Retrieves a description of the system and user functions.
getFunctionColumns	Retrieves a description of the specified catalog's system- or user-function parameters and return type.
getIdentifierQuoteString	Retrieves the String that is used to quote SQL identifiers.
getImportedKeys	Retrieves a description of the primary key columns that are referenced by a table's foreign key columns.
getIndexInfo	Retrieves a description of the indexes and statistics of the given table.
getJDBCMajorVersion	Retrieves the major JDBC version number for this driver.
getJDBCMinorVersion	Retrieves the minor JDBC version number for this driver.
getMaxBinaryLiteralLength	Retrieves the maximum number of hex characters that this database allows in an inline binary literal.
getMaxCatalogNameLength	Retrieves the maximum number of characters that this database allows in a catalog name.
getMaxCharLiteralLength	Retrieves the maximum number of characters that this database allows for a character literal.
getMaxColumnNameLength	Retrieves the maximum number of characters that this database allows for a column name.
getMaxColumnsInGroupBy	Retrieves the maximum number of columns that this database allows in a GROUP BY clause.
getMaxColumnsInIndex	Retrieves the maximum number of columns that this database allows in an index.
getMaxColumnsInOrderBy	Retrieves the maximum number of columns that this database allows in an ORDER BY clause.
getMaxColumnsInSelect	Retrieves the maximum number of columns that this database allows in a SELECT list.
getMaxColumnsInTable	Retrieves the maximum number of columns that this database allows in a table.
getMaxConnections	Retrieves the maximum number of concurrent connections to this database that are possible.
getMaxCursorNameLength	Retrieves the maximum number of characters that this database allows in a cursor name.
getMaxIndexLength	Retrieves the maximum number of bytes that this database allows for an index, including all of the parts of the index.
getMaxProcedureNameLength	Retrieves the maximum number of characters that this database allows in a procedure name.
getMaxRowSize	Retrieves the maximum number of bytes that this database allows in a single row.
getMaxSchemaNameLength	Retrieves the maximum number of characters that this database allows in a schema name.
getMaxStatementLength	Retrieves the maximum number of characters that this database allows in an SQL statement.
getMaxStatements	Retrieves the maximum number of active statements to this database that can be open at the same time.
getMaxTableNameLength	Retrieves the maximum number of characters that this database allows in a table name.
getMaxTablesInSelect	Retrieves the maximum number of tables that this database allows in a SELECT statement.
getMaxUserNameLength	Retrieves the maximum number of characters that this database allows in a user name.
getNumericFunctions	Retrieves a comma-separated list of math functions that are available with this database.
getPrimaryKeys	Retrieves a description of the primary key columns of the given table.
getProcedureColumns	Retrieves a description of the stored procedure parameters and result columns.
getProcedures	Retrieves a description of the stored procedures that are available in the given catalog, schema, or stored procedure name pattern.
getProcedureTerm	Retrieves the preferred term for "procedure" in this database.
getResultSetHoldability	Retrieves the default holdability of result sets for this database.
getRowIdLifetime	Returns a status indicating whether or not SQL RowId data type is supported. If supported, it returns the lifetime for which a RowId object remains valid.
getSchemas	Retrieves the schema names that are available in the current database.
getSchemaTerm	Retrieves the preferred term for "schema" in this database.
getSearchStringEscape	Retrieves the String that can be used to escape wildcard characters.
getSQLKeywords	Retrieves a comma-separated list of all of this database's SQL keywords that are not also SQL92 keywords.
getSQLStateType	Indicates whether the SQLSTATE returned by the SQLException.getSQLState method is X/Open (now known as Open Group), SQL CLI, SQL99 (JDBC 3.0), or SQL:2003 (JDBC 4.0).
getStringFunctions	Retrieves a comma-separated list of String functions that are available with this database.
getSuperTables	Retrieves a description of the table hierarchies that are defined in a particular schema in this database.
getSuperTypes	Retrieves a description of the user-defined type hierarchies that are defined in a particular schema in this database.
getSystemFunctions	Retrieves a comma-separated list of system functions that are available with this database.
getTablePrivileges	Retrieves a description of the access rights for each table that is available in the given catalog, schema, or table name pattern.
getTables	Retrieves a description of the tables that are available in the given catalog, schema, or table name pattern.
getTableTypes	Retrieves the table types that are available in the current database.
getTimeDateFunctions	Retrieves a comma-separated list of the time and date functions that are available with this database.
getTypeInfo	Retrieves a description of all the standard SQL types that are supported by the current database.
getUDTs	Retrieves a description of the user-defined types that are defined in a particular schema.
getURL	Retrieves the URL for this database.
getUserName	Retrieves the user name as known to this database.
getVersionColumns	Retrieves a description of the columns of a table that is automatically updated when any value in a row is updated.
insertsAreDetected	Retrieves whether or not a visible row insert can be detected by calling the method rowInserted method of the SQLServerResultSet class.
isCatalogAtStart	Retrieves whether a catalog appears at the start of a fully qualified table name.
isReadOnly	Retrieves whether this database is in read-only mode.
locatorsUpdateCopy	Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
nullPlusNonNullIsNull	Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.
nullsAreSortedAtEnd	Retrieves whether NULL values are sorted at the end regardless of sort order.
nullsAreSortedAtStart	Retrieves whether NULL values are sorted at the start regardless of sort order.
nullsAreSortedHigh	Retrieves whether NULL values are sorted high.
nullsAreSortedLow	Retrieves whether NULL values are sorted low.
othersDeletesAreVisible	Retrieves whether deletes that are made by others are visible.
othersInsertsAreVisible	Retrieves whether inserts that are made by others are visible.
othersUpdatesAreVisible	Retrieves whether updates that are made by others are visible.
ownDeletesAreVisible	Retrieves whether a result set's own deletes are visible.
ownInsertsAreVisible	Retrieves whether a result set's own inserts are visible.
ownUpdatesAreVisible	Retrieves whether the result set's own updates are visible.
storesLowerCaseIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in lowercase.
storesLowerCaseQuotedIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in lowercase.
storesMixedCaseIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in mixed case.
storesMixedCaseQuotedIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in mixed case.
storesUpperCaseIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in uppercase.
storesUpperCaseQuotedIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in uppercase.
supportsAlterTableWithAddColumn	Retrieves whether this database supports ALTER TABLE with add column.
supportsAlterTableWithDropColumn	Retrieves whether this database supports ALTER TABLE with drop column.
supportsANSI92EntryLevelSQL	Retrieves whether this database supports the ANSI92 entry level SQL grammar.
supportsANSI92FullSQL	Retrieves whether this database supports the ANSI92 full SQL grammar.
supportsANSI92IntermediateSQL	Retrieves whether this database supports the ANSI92 intermediate SQL grammar.
supportsBatchUpdates	Retrieves whether this database supports batch updates.
supportsCatalogsInDataManipulation	Retrieves whether a catalog name can be used in a data manipulation statement.
supportsCatalogsInIndexDefinitions	Retrieves whether a catalog name can be used in an index definition statement.
supportsCatalogsInPrivilegeDefinitions	Retrieves whether a catalog name can be used in a privilege definition statement.
supportsCatalogsInProcedureCalls	Retrieves whether a catalog name can be used in a procedure call statement.
supportsCatalogsInTableDefinitions	Retrieves whether a catalog name can be used in a table definition statement.
supportsColumnAliasing	Retrieves whether this database supports column aliasing.
supportsConvert	Retrieves whether this database supports the CONVERT function between SQL types.
supportsCoreSQLGrammar	Retrieves whether this database supports the ODBC Core SQL grammar.
supportsCorrelatedSubqueries	Retrieves whether this database supports correlated subqueries.
supportsDataDefinitionAndDataManipulationTransactions	Retrieves whether this database supports both data definition and data manipulation statements within a transaction.
supportsDataManipulationTransactionsOnly	Retrieves whether this database supports only data manipulation statements within a transaction.
supportsDifferentTableCorrelationNames	Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
supportsExpressionsInOrderBy	Retrieves whether this database supports expressions in ORDER BY lists.
supportsExtendedSQLGrammar	Retrieves whether this database supports the ODBC Extended SQL grammar.
supportsFullOuterJoins	Retrieves whether this database supports full nested outer joins.
supportsGetGeneratedKeys	Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
supportsGroupBy	Retrieves whether this database supports some form of the GROUP BY clause.
supportsGroupByBeyondSelect	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.
supportsGroupByUnrelated	Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.
supportsIntegrityEnhancementFacility	Retrieves whether this database supports the SQL Integrity Enhancement Facility.
supportsLikeEscapeClause	Retrieves whether this database supports specifying a LIKE escape clause.
supportsLimitedOuterJoins	Retrieves whether this database provides limited support for outer joins.
supportsMinimumSQLGrammar	Retrieves whether this database supports the ODBC Minimum SQL grammar.
supportsMixedCaseIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in mixed case.
supportsMixedCaseQuotedIdentifiers	Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in mixed case.
supportsMultipleOpenResults	Retrieves whether it is possible to have multiple SQLServerResultSet objects returned from a SQLServerCallableStatement object simultaneously.
supportsMultipleResultSets	Retrieves whether this database supports getting multiple SQLServerResultSet objects from a single call to the execute method of the SQLServerCallableStatement class.
supportsMultipleTransactions	Retrieves whether this database allows having multiple transactions open at once on different connections.
supportsNamedParameters	Retrieves whether this database supports named parameters in callable statements.
supportsNonNullableColumns	Retrieves whether columns in this database can be defined as non-nullable.
supportsOpenCursorsAcrossCommit	Retrieves whether this database supports keeping cursors open across commits.
supportsOpenCursorsAcrossRollback	Retrieves whether this database supports keeping cursors open across rollbacks.
supportsOpenStatementsAcrossCommit	Retrieves whether this database supports keeping statements open across commits.
supportsOpenStatementsAcrossRollback	Retrieves whether this database supports keeping statements open across rollbacks.
supportsOrderByUnrelated	Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.
supportsOuterJoins	Retrieves whether this database supports some form of outer join.
supportsPositionedDelete	Retrieves whether this database supports positioned DELETE statements.
supportsPositionedUpdate	Retrieves whether this database supports positioned UPDATE statements.
supportsResultSetConcurrency	Retrieves whether this database supports the given concurrency type in combination with the given result set type.
supportsResultSetHoldability	Retrieves whether this database supports the given result set holdability.
supportsResultSetType	Retrieves whether this database supports the given result set type.
supportsSavepoints	Retrieves whether this database supports savepoints.
supportsSchemasInDataManipulation	Retrieves whether a schema name can be used in a data manipulation statement.
supportsSchemasInIndexDefinitions	Retrieves whether a schema name can be used in an index definition statement.
supportsSchemasInPrivilegeDefinitions	Retrieves whether a schema name can be used in a privilege definition statement.
supportsSchemasInProcedureCalls	Retrieves whether a schema name can be used in a procedure call statement.
supportsSchemasInTableDefinitions	Retrieves whether a schema name can be used in a table definition statement.
supportsSelectForUpdate	Retrieves whether this database supports SELECT FOR UPDATE statements.
supportsStatementPooling	Retrieves whether this database supports statement pooling.
supportsStoredFunctionsUsingCallSyntax	Indicates whether the current database supports invoking user- or vendor-defined functions by using the stored procedure escape syntax.
supportsStoredProcedures	Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
supportsSubqueriesInComparisons	Retrieves whether this database supports subqueries in comparison expressions.
supportsSubqueriesInExists	Retrieves whether this database supports subqueries in EXISTS expressions.
supportsSubqueriesInIns	Retrieves whether this database supports subqueries in IN statements.
supportsSubqueriesInQuantifieds	Retrieves whether this database supports subqueries in quantified expressions.
supportsTableCorrelationNames	Retrieves whether this database supports table correlation names.
supportsTransactionIsolationLevel	Retrieves whether this database supports the given transaction isolation level.
supportsTransactions	Retrieves whether this database supports transactions.
supportsUnion	Retrieves whether this database supports SQL UNION.
supportsUnionAll	Retrieves whether this database supports SQL UNION ALL.
updatesAreDetected	Retrieves whether or not a visible row update can be detected by calling the rowUpdated method of the SQLServerResultSet class.
usesLocalFilePerTable	Retrieves whether this database uses a file for each table.
usesLocalFiles	Retrieves whether this database stores tables in a local file.

Inherited Methods

Class inherited from:	Methods
java.lang.Object	clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait
java.sql.Wrapper	isWrapperFor, unwrap

SQLServerDatabaseMetaData Members

Constructors

Fields

Inherited Fields

Methods

Inherited Methods

See Also

Reference

Additional resources