SQLServerDatabaseMetaData Members

 

DownloadDownload JDBC Driver

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

None.

None.

NameDescription
java.sql.DatabaseMetaDataattributeNoNulls, 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
NameDescription
allProceduresAreCallableRetrieves whether the current user has permissions to call all the procedures returned by the getProcedures method.
allTablesAreSelectableRetrieves whether the current user has permissions to use all the tables returned by the getTables method in a SELECT statement.
autoCommitFailureClosesAllResultSetsIndicates 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.
dataDefinitionCausesTransactionCommitRetrieves whether a data definition statement within a transaction forces the transaction to commit.
dataDefinitionIgnoredInTransactionsRetrieves whether this database ignores a data definition statement within a transaction.
deletesAreDetectedRetrieves whether or not a visible row delete can be detected by calling the rowDeleted method of the SQLServerResultSet class.
doesMaxRowSizeIncludeBlobsRetrieves whether the return value for the getMaxRowSize method includes the SQL data types LONGVARCHAR and LONGVARBINARY.
getAttributesRetrieves a description of the given attribute of the given type for a user-defined type that is available in the given schema and catalog.
getBestRowIdentifierRetrieves a description of the optimal set of columns of a table that uniquely identifies a row.
getCatalogsRetrieves the catalog names that are available in the connected server.
getCatalogSeparatorRetrieves the String that this database uses as the separator between a catalog and table name.
getCatalogTermRetrieves the database vendor's preferred term for "catalog".
getClientInfoPropertiesRetrieves a list of the client information properties that the driver supports.
getColumnPrivilegesRetrieves a description of the access rights for the columns in a table.
getColumnsRetrieves a description of the table columns that are available in the specified catalog.
getConnectionRetrieves the connection that produced this metadata object.
getCrossReferenceRetrieves 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.
getDatabaseMajorVersionRetrieves the major version number of the underlying database.
getDatabaseMinorVersionRetrieves the minor version number of the underlying database.
getDatabaseProductNameRetrieves the name of this database product.
getDatabaseProductVersionRetrieves the version number of this database product.
getDefaultTransactionIsolationRetrieves the default transaction isolation level for this database.
getDriverMajorVersionRetrieves the major version number of this JDBC driver.
getDriverMinorVersionRetrieves the minor version number of this JDBC driver.
getDriverNameRetrieves the name of this JDBC driver.
getDriverVersionRetrieves the version number of this JDBC driver.
getExportedKeysRetrieves a description of the foreign key columns that reference the given table's primary key columns.
getExtraNameCharactersRetrieves all the extra characters that can be used in unquoted identifier names, for example, those beyond a-z, A-Z, 0-9, and _.
getFunctionsRetrieves a description of the system and user functions.
getFunctionColumnsRetrieves a description of the specified catalog's system- or user-function parameters and return type.
getIdentifierQuoteStringRetrieves the String that is used to quote SQL identifiers.
getImportedKeysRetrieves a description of the primary key columns that are referenced by a table's foreign key columns.
getIndexInfoRetrieves a description of the indexes and statistics of the given table.
getJDBCMajorVersionRetrieves the major JDBC version number for this driver.
getJDBCMinorVersionRetrieves the minor JDBC version number for this driver.
getMaxBinaryLiteralLengthRetrieves the maximum number of hex characters that this database allows in an inline binary literal.
getMaxCatalogNameLengthRetrieves the maximum number of characters that this database allows in a catalog name.
getMaxCharLiteralLengthRetrieves the maximum number of characters that this database allows for a character literal.
getMaxColumnNameLengthRetrieves the maximum number of characters that this database allows for a column name.
getMaxColumnsInGroupByRetrieves the maximum number of columns that this database allows in a GROUP BY clause.
getMaxColumnsInIndexRetrieves the maximum number of columns that this database allows in an index.
getMaxColumnsInOrderByRetrieves the maximum number of columns that this database allows in an ORDER BY clause.
getMaxColumnsInSelectRetrieves the maximum number of columns that this database allows in a SELECT list.
getMaxColumnsInTableRetrieves the maximum number of columns that this database allows in a table.
getMaxConnectionsRetrieves the maximum number of concurrent connections to this database that are possible.
getMaxCursorNameLengthRetrieves the maximum number of characters that this database allows in a cursor name.
getMaxIndexLengthRetrieves the maximum number of bytes that this database allows for an index, including all of the parts of the index.
getMaxProcedureNameLengthRetrieves the maximum number of characters that this database allows in a procedure name.
getMaxRowSizeRetrieves the maximum number of bytes that this database allows in a single row.
getMaxSchemaNameLengthRetrieves the maximum number of characters that this database allows in a schema name.
getMaxStatementLengthRetrieves the maximum number of characters that this database allows in an SQL statement.
getMaxStatementsRetrieves the maximum number of active statements to this database that can be open at the same time.
getMaxTableNameLengthRetrieves the maximum number of characters that this database allows in a table name.
getMaxTablesInSelectRetrieves the maximum number of tables that this database allows in a SELECT statement.
getMaxUserNameLengthRetrieves the maximum number of characters that this database allows in a user name.
getNumericFunctionsRetrieves a comma-separated list of math functions that are available with this database.
getPrimaryKeysRetrieves a description of the primary key columns of the given table.
getProcedureColumnsRetrieves a description of the stored procedure parameters and result columns.
getProceduresRetrieves a description of the stored procedures that are available in the given catalog, schema, or stored procedure name pattern.
getProcedureTermRetrieves the preferred term for "procedure" in this database.
getResultSetHoldabilityRetrieves the default holdability of result sets for this database.
getRowIdLifetimeReturns 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.
getSchemasRetrieves the schema names that are available in the current database.
getSchemaTermRetrieves the preferred term for "schema" in this database.
getSearchStringEscapeRetrieves the String that can be used to escape wildcard characters.
getSQLKeywordsRetrieves a comma-separated list of all of this database's SQL keywords that are not also SQL92 keywords.
getSQLStateTypeIndicates 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).
getStringFunctionsRetrieves a comma-separated list of String functions that are available with this database.
getSuperTablesRetrieves a description of the table hierarchies that are defined in a particular schema in this database.
getSuperTypesRetrieves a description of the user-defined type hierarchies that are defined in a particular schema in this database.
getSystemFunctionsRetrieves a comma-separated list of system functions that are available with this database.
getTablePrivilegesRetrieves a description of the access rights for each table that is available in the given catalog, schema, or table name pattern.
getTablesRetrieves a description of the tables that are available in the given catalog, schema, or table name pattern.
getTableTypesRetrieves the table types that are available in the current database.
getTimeDateFunctionsRetrieves a comma-separated list of the time and date functions that are available with this database.
getTypeInfoRetrieves a description of all the standard SQL types that are supported by the current database.
getUDTsRetrieves a description of the user-defined types that are defined in a particular schema.
getURLRetrieves the URL for this database.
getUserNameRetrieves the user name as known to this database.
getVersionColumnsRetrieves a description of the columns of a table that is automatically updated when any value in a row is updated.
insertsAreDetectedRetrieves whether or not a visible row insert can be detected by calling the method rowInserted method of the SQLServerResultSet class.
isCatalogAtStartRetrieves whether a catalog appears at the start of a fully qualified table name.
isReadOnlyRetrieves whether this database is in read-only mode.
locatorsUpdateCopyIndicates whether updates made to a LOB are made on a copy or directly to the LOB.
nullPlusNonNullIsNullIndicates whether this database supports concatenations between NULL and non-NULL values being NULL.
nullsAreSortedAtEndRetrieves whether NULL values are sorted at the end regardless of sort order.
nullsAreSortedAtStartRetrieves whether NULL values are sorted at the start regardless of sort order.
nullsAreSortedHighRetrieves whether NULL values are sorted high.
nullsAreSortedLowRetrieves whether NULL values are sorted low.
othersDeletesAreVisibleRetrieves whether deletes that are made by others are visible.
othersInsertsAreVisibleRetrieves whether inserts that are made by others are visible.
othersUpdatesAreVisibleRetrieves whether updates that are made by others are visible.
ownDeletesAreVisibleRetrieves whether a result set's own deletes are visible.
ownInsertsAreVisibleRetrieves whether a result set's own inserts are visible.
ownUpdatesAreVisibleRetrieves whether the result set's own updates are visible.
storesLowerCaseIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in lowercase.
storesLowerCaseQuotedIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in lowercase.
storesMixedCaseIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in mixed case.
storesMixedCaseQuotedIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in mixed case.
storesUpperCaseIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in uppercase.
storesUpperCaseQuotedIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in uppercase.
supportsAlterTableWithAddColumnRetrieves whether this database supports ALTER TABLE with add column.
supportsAlterTableWithDropColumnRetrieves whether this database supports ALTER TABLE with drop column.
supportsANSI92EntryLevelSQLRetrieves whether this database supports the ANSI92 entry level SQL grammar.
supportsANSI92FullSQLRetrieves whether this database supports the ANSI92 full SQL grammar.
supportsANSI92IntermediateSQLRetrieves whether this database supports the ANSI92 intermediate SQL grammar.
supportsBatchUpdatesRetrieves whether this database supports batch updates.
supportsCatalogsInDataManipulationRetrieves whether a catalog name can be used in a data manipulation statement.
supportsCatalogsInIndexDefinitionsRetrieves whether a catalog name can be used in an index definition statement.
supportsCatalogsInPrivilegeDefinitionsRetrieves whether a catalog name can be used in a privilege definition statement.
supportsCatalogsInProcedureCallsRetrieves whether a catalog name can be used in a procedure call statement.
supportsCatalogsInTableDefinitionsRetrieves whether a catalog name can be used in a table definition statement.
supportsColumnAliasingRetrieves whether this database supports column aliasing.
supportsConvertRetrieves whether this database supports the CONVERT function between SQL types.
supportsCoreSQLGrammarRetrieves whether this database supports the ODBC Core SQL grammar.
supportsCorrelatedSubqueriesRetrieves whether this database supports correlated subqueries.
supportsDataDefinitionAndDataManipulationTransactionsRetrieves whether this database supports both data definition and data manipulation statements within a transaction.
supportsDataManipulationTransactionsOnlyRetrieves whether this database supports only data manipulation statements within a transaction.
supportsDifferentTableCorrelationNamesRetrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
supportsExpressionsInOrderByRetrieves whether this database supports expressions in ORDER BY lists.
supportsExtendedSQLGrammarRetrieves whether this database supports the ODBC Extended SQL grammar.
supportsFullOuterJoinsRetrieves whether this database supports full nested outer joins.
supportsGetGeneratedKeysRetrieves whether auto-generated keys can be retrieved after a statement has been executed.
supportsGroupByRetrieves whether this database supports some form of the GROUP BY clause.
supportsGroupByBeyondSelectRetrieves 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.
supportsGroupByUnrelatedRetrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.
supportsIntegrityEnhancementFacilityRetrieves whether this database supports the SQL Integrity Enhancement Facility.
supportsLikeEscapeClauseRetrieves whether this database supports specifying a LIKE escape clause.
supportsLimitedOuterJoinsRetrieves whether this database provides limited support for outer joins.
supportsMinimumSQLGrammarRetrieves whether this database supports the ODBC Minimum SQL grammar.
supportsMixedCaseIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in mixed case.
supportsMixedCaseQuotedIdentifiersRetrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in mixed case.
supportsMultipleOpenResultsRetrieves whether it is possible to have multiple SQLServerResultSet objects returned from a SQLServerCallableStatement object simultaneously.
supportsMultipleResultSetsRetrieves whether this database supports getting multiple SQLServerResultSet objects from a single call to the execute method of the SQLServerCallableStatement class.
supportsMultipleTransactionsRetrieves whether this database allows having multiple transactions open at once on different connections.
supportsNamedParametersRetrieves whether this database supports named parameters in callable statements.
supportsNonNullableColumnsRetrieves whether columns in this database can be defined as non-nullable.
supportsOpenCursorsAcrossCommitRetrieves whether this database supports keeping cursors open across commits.
supportsOpenCursorsAcrossRollbackRetrieves whether this database supports keeping cursors open across rollbacks.
supportsOpenStatementsAcrossCommitRetrieves whether this database supports keeping statements open across commits.
supportsOpenStatementsAcrossRollbackRetrieves whether this database supports keeping statements open across rollbacks.
supportsOrderByUnrelatedRetrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.
supportsOuterJoinsRetrieves whether this database supports some form of outer join.
supportsPositionedDeleteRetrieves whether this database supports positioned DELETE statements.
supportsPositionedUpdateRetrieves whether this database supports positioned UPDATE statements.
supportsResultSetConcurrencyRetrieves whether this database supports the given concurrency type in combination with the given result set type.
supportsResultSetHoldabilityRetrieves whether this database supports the given result set holdability.
supportsResultSetTypeRetrieves whether this database supports the given result set type.
supportsSavepointsRetrieves whether this database supports savepoints.
supportsSchemasInDataManipulationRetrieves whether a schema name can be used in a data manipulation statement.
supportsSchemasInIndexDefinitionsRetrieves whether a schema name can be used in an index definition statement.
supportsSchemasInPrivilegeDefinitionsRetrieves whether a schema name can be used in a privilege definition statement.
supportsSchemasInProcedureCallsRetrieves whether a schema name can be used in a procedure call statement.
supportsSchemasInTableDefinitionsRetrieves whether a schema name can be used in a table definition statement.
supportsSelectForUpdateRetrieves whether this database supports SELECT FOR UPDATE statements.
supportsStatementPoolingRetrieves whether this database supports statement pooling.
supportsStoredFunctionsUsingCallSyntaxIndicates whether the current database supports invoking user- or vendor-defined functions by using the stored procedure escape syntax.
supportsStoredProceduresRetrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
supportsSubqueriesInComparisonsRetrieves whether this database supports subqueries in comparison expressions.
supportsSubqueriesInExistsRetrieves whether this database supports subqueries in EXISTS expressions.
supportsSubqueriesInInsRetrieves whether this database supports subqueries in IN statements.
supportsSubqueriesInQuantifiedsRetrieves whether this database supports subqueries in quantified expressions.
supportsTableCorrelationNamesRetrieves whether this database supports table correlation names.
supportsTransactionIsolationLevelRetrieves whether this database supports the given transaction isolation level.
supportsTransactionsRetrieves whether this database supports transactions.
supportsUnionRetrieves whether this database supports SQL UNION.
supportsUnionAllRetrieves whether this database supports SQL UNION ALL.
updatesAreDetectedRetrieves whether or not a visible row update can be detected by calling the rowUpdated method of the SQLServerResultSet class.
usesLocalFilePerTableRetrieves whether this database uses a file for each table.
usesLocalFilesRetrieves whether this database stores tables in a local file.
Class inherited from:Methods
java.lang.Objectclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait
java.sql.WrapperisWrapperFor, unwrap

SQLServerDatabaseMetaData Class

Community Additions

ADD
Show: