SQLServerDatabaseMetaData Members

Download JDBC driver

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

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 a 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 Indicates 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

See Also

SQLServerDatabaseMetaData Class