SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008

Product Documentation

SQL Server JDBC Driver 2.0 Documentation

JDBC Driver API Reference

SQLServerDatabaseMetaData Class

SQLServerDatabaseMetaData Methods

allProceduresAreCallable Method (SQLServerDatabaseMetaData)

allTablesAreSelectable Method (SQLServerDatabaseMetaData)

autoCommitFailureClosesAllResultSets Method (SQLServerDatabaseMetaData)

dataDefinitionCausesTransactionCommit Method (SQLServerDatabaseMetaData)

dataDefinitionIgnoredInTransactions Method (SQLServerDatabaseMetaData)

deletesAreDetected Method (SQLServerDatabaseMetaData)

doesMaxRowSizeIncludeBlobs Method (SQLServerDatabaseMetaData)

getAttributes Method (SQLServerDatabaseMetaData)

getBestRowIdentifier Method (SQLServerDatabaseMetaData)

getCatalogs Method (SQLServerDatabaseMetaData)

getCatalogSeparator Method (SQLServerDatabaseMetaData)

getCatalogTerm Method (SQLServerDatabaseMetaData)

getClientInfoProperties Method (SQLServerDatabaseMetaData)

getColumnPrivileges Method (SQLServerDatabaseMetaData)

getColumns Method (SQLServerDatabaseMetaData)

getConnection Method (SQLServerDatabaseMetaData)

getCrossReference Method (SQLServerDatabaseMetaData)

getDatabaseMajorVersion Method (SQLServerDatabaseMetaData)

getDatabaseMinorVersion Method (SQLServerDatabaseMetaData)

getDatabaseProductName Method (SQLServerDatabaseMetaData)

getDatabaseProductVersion Method (SQLServerDatabaseMetaData)

getDefaultTransactionIsolation Method (SQLServerDatabaseMetaData)

getDriverMajorVersion Method (SQLServerDatabaseMetaData)

getDriverMinorVersion Method (SQLServerDatabaseMetaData)

getDriverName Method (SQLServerDatabaseMetaData)

getDriverVersion Method (SQLServerDatabaseMetaData)

getExportedKeys Method (SQLServerDatabaseMetaData)

getExtraNameCharacters Method (SQLServerDatabaseMetaData)

getFunctions Method (SQLServerDatabaseMetaData)

getFunctionColumns Method (SQLServerDatabaseMetaData)

getIdentifierQuoteString Method (SQLServerDatabaseMetaData)

getImportedKeys Method (SQLServerDatabaseMetaData)

getIndexInfo Method (SQLServerDatabaseMetaData)

getJDBCMajorVersion Method (SQLServerDatabaseMetaData)

getJDBCMinorVersion Method (SQLServerDatabaseMetaData)

getMaxBinaryLiteralLength Method (SQLServerDatabaseMetaData)

getMaxCatalogNameLength Method (SQLServerDatabaseMetaData)

getMaxCharLiteralLength Method (SQLServerDatabaseMetaData)

getMaxColumnNameLength Method (SQLServerDatabaseMetaData)

getMaxColumnsInGroupBy Method (SQLServerDatabaseMetaData)

getMaxColumnsInIndex Method (SQLServerDatabaseMetaData)

getMaxColumnsInOrderBy Method (SQLServerDatabaseMetaData)

getMaxColumnsInSelect Method (SQLServerDatabaseMetaData)

getMaxColumnsInTable Method (SQLServerDatabaseMetaData)

getMaxConnections Method (SQLServerDatabaseMetaData)

getMaxCursorNameLength Method (SQLServerDatabaseMetaData)

getMaxIndexLength Method (SQLServerDatabaseMetaData)

getMaxProcedureNameLength Method (SQLServerDatabaseMetaData)

getMaxRowSize Method (SQLServerDatabaseMetaData)

getMaxSchemaNameLength Method (SQLServerDatabaseMetaData)

getMaxStatementLength Method (SQLServerDatabaseMetaData)

getMaxStatements Method (SQLServerDatabaseMetaData)

getMaxTableNameLength Method (SQLServerDatabaseMetaData)

getMaxTablesInSelect Method (SQLServerDatabaseMetaData)

getMaxUserNameLength Method (SQLServerDatabaseMetaData)

getNumericFunctions Method (SQLServerDatabaseMetaData)

getPrimaryKeys Method (SQLServerDatabaseMetaData)

getProcedureColumns Method (SQLServerDatabaseMetaData)

getProcedures Method (SQLServerDatabaseMetaData)

getProcedureTerm Method (SQLServerDatabaseMetaData)

getResultSetHoldability Method (SQLServerDatabaseMetaData)

getRowIdLifetime Method (SQLServerDatabaseMetaData)

getSchemas Method (SQLServerDatabaseMetaData)

getSchemaTerm Method (SQLServerDatabaseMetaData)

getSearchStringEscape Method (SQLServerDatabaseMetaData)

getSQLKeywords Method (SQLServerDatabaseMetaData)

getSQLStateType Method (SQLServerDatabaseMetaData)

getStringFunctions Method (SQLServerDatabaseMetaData)

getSuperTables Method (SQLServerDatabaseMetaData)

getSuperTypes Method (SQLServerDatabaseMetaData)

getSystemFunctions Method (SQLServerDatabaseMetaData)

getTablePrivileges Method (SQLServerDatabaseMetaData)

getTables Method (SQLServerDatabaseMetaData)

getTableTypes Method (SQLServerDatabaseMetaData)

getTimeDateFunctions Method (SQLServerDatabaseMetaData)

getTypeInfo Method (SQLServerDatabaseMetaData)

getUDTs Method (SQLServerDatabaseMetaData)

getURL Method (SQLServerDatabaseMetaData)

getUserName Method (SQLServerDatabaseMetaData)

getVersionColumns Method (SQLServerDatabaseMetaData)

insertsAreDetected Method (SQLServerDatabaseMetaData)

isCatalogAtStart Method (SQLServerDatabaseMetaData)

isReadOnly Method (SQLServerDatabaseMetaData)

locatorsUpdateCopy Method (SQLServerDatabaseMetaData)

nullPlusNonNullIsNull Method (SQLServerDatabaseMetaData)

nullsAreSortedAtEnd Method (SQLServerDatabaseMetaData)

nullsAreSortedAtStart Method (SQLServerDatabaseMetaData)

nullsAreSortedHigh Method (SQLServerDatabaseMetaData)

nullsAreSortedLow Method (SQLServerDatabaseMetaData)

othersDeletesAreVisible Method (SQLServerDatabaseMetaData)

othersInsertsAreVisible Method (SQLServerDatabaseMetaData)

othersUpdatesAreVisible Method (SQLServerDatabaseMetaData)

ownDeletesAreVisible Method (SQLServerDatabaseMetaData)

ownInsertsAreVisible Method (SQLServerDatabaseMetaData)

ownUpdatesAreVisible Method (SQLServerDatabaseMetaData)

storesLowerCaseIdentifiers Method (SQLServerDatabaseMetaData)

storesLowerCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

storesMixedCaseIdentifiers Method (SQLServerDatabaseMetaData)

storesMixedCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

storesUpperCaseIdentifiers Method (SQLServerDatabaseMetaData)

storesUpperCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

supportsAlterTableWithAddColumn Method (SQLServerDatabaseMetaData)

supportsAlterTableWithDropColumn Method (SQLServerDatabaseMetaData)

supportsANSI92EntryLevelSQL Method (SQLServerDatabaseMetaData)

supportsANSI92FullSQL Method (SQLServerDatabaseMetaData)

supportsANSI92IntermediateSQL Method (SQLServerDatabaseMetaData)

supportsBatchUpdates Method (SQLServerDatabaseMetaData)

supportsCatalogsInDataManipulation Method (SQLServerDatabaseMetaData)

supportsCatalogsInIndexDefinitions Method (SQLServerDatabaseMetaData)

supportsCatalogsInPrivilegeDefinitions Method (SQLServerDatabaseMetaData)

supportsCatalogsInProcedureCalls Method (SQLServerDatabaseMetaData)

supportsCatalogsInTableDefinitions Method (SQLServerDatabaseMetaData)

supportsColumnAliasing Method (SQLServerDatabaseMetaData)

supportsConvert Method (SQLServerDatabaseMetaData)

supportsCoreSQLGrammar Method (SQLServerDatabaseMetaData)

supportsCorrelatedSubqueries Method (SQLServerDatabaseMetaData)

supportsDataDefinitionAndDataManipulationTransactions Method (SQLServerDatabaseMetaData)

supportsDataManipulationTransactionsOnly Method (SQLServerDatabaseMetaData)

supportsDifferentTableCorrelationNames Method (SQLServerDatabaseMetaData)

supportsExpressionsInOrderBy Method (SQLServerDatabaseMetaData)

supportsExtendedSQLGrammar Method (SQLServerDatabaseMetaData)

supportsFullOuterJoins Method (SQLServerDatabaseMetaData)

supportsGetGeneratedKeys Method (SQLServerDatabaseMetaData)

supportsGroupBy Method (SQLServerDatabaseMetaData)

supportsGroupByBeyondSelect Method (SQLServerDatabaseMetaData)

supportsGroupByUnrelated Method (SQLServerDatabaseMetaData)

supportsIntegrityEnhancementFacility Method (SQLServerDatabaseMetaData)

supportsLikeEscapeClause Method (SQLServerDatabaseMetaData)

supportsLimitedOuterJoins Method (SQLServerDatabaseMetaData)

supportsMinimumSQLGrammar Method (SQLServerDatabaseMetaData)

supportsMixedCaseIdentifiers Method (SQLServerDatabaseMetaData)

supportsMixedCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

supportsMultipleOpenResults Method (SQLServerDatabaseMetaData)

supportsMultipleResultSets Method (SQLServerDatabaseMetaData)

supportsMultipleTransactions Method (SQLServerDatabaseMetaData)

supportsNamedParameters Method (SQLServerDatabaseMetaData)

supportsNonNullableColumns Method (SQLServerDatabaseMetaData)

supportsOpenCursorsAcrossCommit Method (SQLServerDatabaseMetaData)

supportsOpenCursorsAcrossRollback Method (SQLServerDatabaseMetaData)

supportsOpenStatementsAcrossCommit Method (SQLServerDatabaseMetaData)

supportsOpenStatementsAcrossRollback Method (SQLServerDatabaseMetaData)

supportsOrderByUnrelated Method (SQLServerDatabaseMetaData)

supportsOuterJoins Method (SQLServerDatabaseMetaData)

supportsPositionedDelete Method (SQLServerDatabaseMetaData)

supportsPositionedUpdate Method (SQLServerDatabaseMetaData)

supportsResultSetConcurrency Method (SQLServerDatabaseMetaData)

supportsResultSetHoldability Method (SQLServerDatabaseMetaData)

supportsResultSetType Method (SQLServerDatabaseMetaData)

supportsSavepoints Method (SQLServerDatabaseMetaData)

supportsSchemasInDataManipulation Method (SQLServerDatabaseMetaData)

supportsSchemasInIndexDefinitions Method (SQLServerDatabaseMetaData)

supportsSchemasInPrivilegeDefinitions Method (SQLServerDatabaseMetaData)

supportsSchemasInProcedureCalls Method (SQLServerDatabaseMetaData)

supportsSchemasInTableDefinitions Method (SQLServerDatabaseMetaData)

supportsSelectForUpdate Method (SQLServerDatabaseMetaData)

supportsStatementPooling Method (SQLServerDatabaseMetaData)

supportsStoredProcedures Method (SQLServerDatabaseMetaData)

supportsStoredFunctionsUsingCallSyntax Method (SQLServerDatabaseMetaData)

supportsSubqueriesInComparisons Method (SQLServerDatabaseMetaData)

supportsSubqueriesInExists Method (SQLServerDatabaseMetaData)

supportsSubqueriesInIns Method (SQLServerDatabaseMetaData)

supportsSubqueriesInQuantifieds Method (SQLServerDatabaseMetaData)

supportsTableCorrelationNames Method (SQLServerDatabaseMetaData)

supportsTransactionIsolationLevel Method (SQLServerDatabaseMetaData)

supportsTransactions Method (SQLServerDatabaseMetaData)

supportsUnion Method (SQLServerDatabaseMetaData)

supportsUnionAll Method (SQLServerDatabaseMetaData)

updatesAreDetected Method (SQLServerDatabaseMetaData)

usesLocalFilePerTable Method (SQLServerDatabaseMetaData)

usesLocalFiles Method (SQLServerDatabaseMetaData)

Minimize

This topic has not yet been rated - Rate this topic

getDefaultTransactionIsolation Method (SQLServerDatabaseMetaData)

Retrieves the default transaction isolation level for this database.


public int getDefaultTransactionIsolation()

An int that indicates the default transaction isolation level.

SQLServerException

This getDefaultTransactionIsolation method is specified by the getDefaultTransactionIsolation method in the java.sql.DatabaseMetaData interface.

When using the Microsoft SQL Server JDBC Driver with a SQL Server database, this method returns either a value of TRANSACTION_READ_COMMITTED, or the int value 2.

Reference

SQLServerDatabaseMetaData Class

Concepts

SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.