SQLServerDatabaseMetaData Members
The following tables list the members that are exposed by the SQLServerDatabaseMetaData class.
None.
None.
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 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. |
Class inherited from: | Methods |
---|---|
java.lang.Object | clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait |
java.sql.Wrapper | isWrapperFor, unwrap |