Export (0) Print
Expand All

SQLServerDatabaseMetaData Members

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

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

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

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.

Class inherited from:

Methods

java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait

java.sql.Wrapper

isWrapperFor, unwrap

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft