SQLServerDatabaseMetaData Members
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 |