SQLServerDatabaseMetaData Methods
The following tables list the methods that are exposed by the SQLServerDatabaseMetaData class.
Methods
| Name | Description |
|---|---|
| Retrieves whether the current user has permissions to call all the procedures returned by the getProcedures method. | |
| Retrieves whether the current user has permissions to use all the tables returned by the getTables method in a SELECT statement. | |
| Retrieves whether a data definition statement within a transaction forces the transaction to commit. | |
| Retrieves whether this database ignores a data definition statement within a transaction. | |
| Retrieves whether or not a visible row delete can be detected by calling the rowDeleted method of the SQLServerResultSet class. | |
| Retrieves whether the return value for the getMaxRowSize method includes the SQL data types LONGVARCHAR and LONGVARBINARY. | |
| 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. | |
| Retrieves a description of the optimal set of columns of a table that uniquely identifies a row. | |
| Retrieves the catalog names that are available in the connected server. | |
| Retrieves the String that this database uses as the separator between a catalog and table name. | |
| Retrieves the database vendor's preferred term for "catalog". | |
| Retrieves a description of the access rights for the columns in a table. | |
| Retrieves a description of the table columns that are available in the specified catalog. | |
| Retrieves the connection that produced this metadata object. | |
| 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. | |
| Retrieves the major version number of the underlying database. | |
| Retrieves the minor version number of the underlying database. | |
| Retrieves the name of this database product. | |
| Retrieves the version number of this database product. | |
| Retrieves this database's default transaction isolation level. | |
| Retrieves the major version number of this JDBC driver. | |
| Retrieves the minor version number of this JDBC driver. | |
| Retrieves the name of this JDBC driver. | |
| Retrieves the version number of this JDBC driver. | |
| Retrieves a description of the foreign key columns that reference the primary key columns of the given table. | |
| Retrieves all the extra characters that can be used in unquoted identifier names, such as those beyond a-z, A-Z, 0-9, and _. | |
| Retrieves the String that is used to quote SQL identifiers. | |
| Retrieves a description of the primary key columns that are referenced by the foreign key columns of a table. | |
| Retrieves a description of the indexes and statistics of a given table. | |
| Retrieves the major JDBC version number for this driver. | |
| Retrieves the minor JDBC version number for this driver. | |
| Retrieves the maximum number of hexadecimal characters that this database allows in an inline binary literal. | |
| Retrieves the maximum number of characters that this database allows in a catalog name. | |
| Retrieves the maximum number of characters that this database allows for a character literal. | |
| Retrieves the maximum number of characters that this database allows for a column name. | |
| Retrieves the maximum number of columns that this database allows in a GROUP BY clause. | |
| Retrieves the maximum number of columns that this database allows in an index. | |
| Retrieves the maximum number of columns that this database allows in an ORDER BY clause. | |
| Retrieves the maximum number of columns that this database allows in a SELECT list. | |
| Retrieves the maximum number of columns that this database allows in a table. | |
| Retrieves the maximum number of concurrent connections to this database that are possible. | |
| Retrieves the maximum number of characters that this database allows in a cursor name. | |
| Retrieves the maximum number of bytes that this database allows for an index, including all parts of the index. | |
| Retrieves the maximum number of characters that this database allows in a procedure name. | |
| Retrieves the maximum number of bytes that this database allows in a single row. | |
| Retrieves the maximum number of characters that this database allows in a schema name. | |
| Retrieves the maximum number of characters that this database allows in an SQL statement. | |
| Retrieves the maximum number of active statements to this database that can be open at the same time. | |
| Retrieves the maximum number of characters that this database allows in a table name. | |
| Retrieves the maximum number of tables that this database allows in a SELECT statement. | |
| Retrieves the maximum number of characters that this database allows in a user name. | |
| Retrieves a comma-separated list of math functions that are available with this database. | |
| Retrieves a description of the primary key columns of the given table. | |
| Retrieves a description of the stored procedure parameters and result columns. | |
| Retrieves a description of the stored procedures that are available in the given catalog, schema, or stored procedure name pattern. | |
| Retrieves the preferred term for "procedure" in this database. | |
| Retrieves the default holdability of result sets for this database. | |
| Retrieves the schema names that are available in the current database. | |
| Retrieves the preferred term for "schema" in this database. | |
| Retrieves the String that can be used to escape wildcard characters. | |
| Retrieves a comma-separated list of all of this database's SQL keywords that are not also SQL92 keywords. | |
| Indicates whether the SQLSTATE returned by the SQLException.getSQLState method is X/Open (now known as Open Group), SQL CLI, or SQL99. | |
| Retrieves a comma-separated list of String functions available with this database. | |
| Retrieves a description of the table hierarchies defined in a particular schema in this database. | |
| Retrieves a description of the user-defined type hierarchies that are defined in a particular schema in this database. | |
| Retrieves a comma-separated list of system functions that are available with this database. | |
| Retrieves a description of the access rights for each table that is available in the given catalog, schema, or table name pattern. | |
| Retrieves a description of the tables that are available in the given catalog, schema, or table name pattern. | |
| Retrieves the table types that are available in the current database. | |
| Retrieves a comma-separated list of the time and date functions that are available with this database. | |
| Retrieves a description of all the standard SQL types supported by the current database. | |
| Retrieves a description of the user-defined types that are defined in a particular schema. | |
| Retrieves the URL for this database. | |
| Retrieves the user name as known to this database. | |
| Retrieves a description of the columns of a table that is automatically updated when any value in a row is updated. | |
| Retrieves whether or not a visible row insert can be detected by calling the method rowInserted method of the SQLServerResultSet class. | |
| Retrieves whether a catalog appears at the start of a fully qualified table name. | |
| Retrieves whether this database is in read-only mode. | |
| Indicates whether updates made to a LOB are made on a copy or directly to the LOB. | |
| Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL. | |
| Retrieves whether NULL values are sorted at the end regardless of sort order. | |
| Retrieves whether NULL values are sorted at the start regardless of sort order. | |
| Retrieves whether NULL values are sorted high. | |
| Retrieves whether NULL values are sorted low. | |
| Retrieves whether deletes made by others are visible. | |
| Retrieves whether inserts made by others are visible. | |
| Retrieves whether updates made by others are visible. | |
| Retrieves whether a result set's own deletes are visible. | |
| Retrieves whether a result set's own inserts are visible. | |
| Retrieves whether the result set's own updates are visible. | |
| Retrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in lowercase. | |
| Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in lowercase. | |
| 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. | |
| Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in mixed case. | |
| Retrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-insensitive and stores them in uppercase. | |
| Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-insensitive and stores them in uppercase. | |
| Retrieves whether this database supports ALTER TABLE with add column. | |
| Retrieves whether this database supports ALTER TABLE with drop column. | |
| Retrieves whether this database supports the ANSI92 entry level SQL grammar. | |
| Retrieves whether this database supports the ANSI92 full SQL grammar. | |
| Retrieves whether this database supports the ANSI92 intermediate SQL grammar. | |
| Retrieves whether this database supports batch updates. | |
| Retrieves whether a catalog name can be used in a data manipulation statement. | |
| Retrieves whether a catalog name can be used in an index definition statement. | |
| Retrieves whether a catalog name can be used in a privilege definition statement. | |
| Retrieves whether a catalog name can be used in a procedure call statement. | |
| Retrieves whether a catalog name can be used in a table definition statement. | |
| Retrieves whether this database supports column aliasing. | |
| Retrieves whether this database supports the CONVERT function between SQL types. | |
| Retrieves whether this database supports the ODBC Core SQL grammar. | |
| Retrieves whether this database supports correlated subqueries. | |
| Retrieves whether this database supports both data definition and data manipulation statements within a transaction. | |
| Retrieves whether this database supports only data manipulation statements within a transaction. | |
| Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables. | |
| Retrieves whether this database supports expressions in ORDER BY lists. | |
| Retrieves whether this database supports the ODBC Extended SQL grammar. | |
| Retrieves whether this database supports full nested outer joins. | |
| Retrieves whether auto-generated keys can be retrieved after a statement has been executed. | |
| Retrieves whether this database supports some form of the GROUP BY clause. | |
| Retrieves whether this database supports using columns that are not included in the SELECT statement in a GROUP BY clause, provided that all the columns in the SELECT statement are included in the GROUP BY clause. | |
| Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause. | |
| Retrieves whether this database supports the SQL Integrity Enhancement Facility. | |
| Retrieves whether this database supports specifying a LIKE escape clause. | |
| Retrieves whether this database provides limited support for outer joins. | |
| Retrieves whether this database supports the ODBC Minimum SQL grammar. | |
| Retrieves whether this database treats mixed-case SQL identifiers that are not enclosed in quotation marks as case-sensitive and stores them in mixed case. | |
| Retrieves whether this database treats mixed-case SQL identifiers that are enclosed in quotation marks as case-sensitive and stores them in mixed case. | |
| Retrieves whether it is possible to have multiple SQLServerResultSet objects returned from a SQLServerCallableStatement object simultaneously. | |
| Retrieves whether this database supports getting multiple SQLServerResultSet objects from a single call to the execute method of the SQLServerCallableStatement class. | |
| Retrieves whether this database allows having multiple transactions open at the same time on different connections. | |
| Retrieves whether this database supports named parameters in callable statements. | |
| Retrieves whether columns in this database can be defined as non-nullable. | |
| Retrieves whether this database supports keeping cursors open across commits. | |
| Retrieves whether this database supports keeping cursors open across rollbacks. | |
| Retrieves whether this database supports keeping statements open across commits. | |
| Retrieves whether this database supports keeping statements open across rollbacks. | |
| Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause. | |
| Retrieves whether this database supports some form of outer join. | |
| Retrieves whether this database supports positioned DELETE statements. | |
| Retrieves whether this database supports positioned UPDATE statements. | |
| Retrieves whether this database supports the given concurrency type in combination with the given result set type. | |
| Retrieves whether this database supports the given result set holdability. | |
| Retrieves whether this database supports the given result set type. | |
| Retrieves whether this database supports savepoints. | |
| Retrieves whether a schema name can be used in a data manipulation statement. | |
| Retrieves whether a schema name can be used in an index definition statement. | |
| Retrieves whether a schema name can be used in a privilege definition statement. | |
| Retrieves whether a schema name can be used in a procedure call statement. | |
| Retrieves whether a schema name can be used in a table definition statement. | |
| Retrieves whether this database supports SELECT FOR UPDATE statements. | |
| Retrieves whether this database supports statement pooling. | |
| Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax. | |
| Retrieves whether this database supports subqueries in comparison expressions. | |
| Retrieves whether this database supports subqueries in EXISTS expressions. | |
| Retrieves whether this database supports subqueries in IN statements. | |
| Retrieves whether this database supports subqueries in quantified expressions. | |
| Retrieves whether this database supports table correlation names. | |
| Retrieves whether this database supports the given transaction isolation level. | |
| Retrieves whether this database supports transactions. | |
| Retrieves whether this database supports SQL UNION. | |
| Retrieves whether this database supports SQL UNION ALL. | |
| Retrieves whether or not a visible row update can be detected by calling the rowUpdated method of the SQLServerResultSet class. | |
| Retrieves whether this database uses a file for each table. | |
| 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 |