Module com.microsoft.sqlserver.jdbc
Package com.microsoft.sqlserver.jdbc
Class SQLServerDatabaseMetaData
java.lang.Object
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData
- All Implemented Interfaces:
Serializable
,DatabaseMetaData
,Wrapper
public final class SQLServerDatabaseMetaData
extends Object
implements DatabaseMetaData, Serializable
Provides the JDBC database meta data.
The API javadoc for JDBC API methods that this class implements are not repeated here. Please see Sun's JDBC API
interfaces javadoc for those details.
- See Also:
-
Field Summary
Fields inherited from interface java.sql.DatabaseMetaData
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, functionColumnIn, functionColumnInOut, functionColumnOut, functionColumnResult, functionColumnUnknown, functionNoNulls, functionNoTable, functionNullable, functionNullableUnknown, functionResultUnknown, functionReturn, functionReturnsTable, 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
-
Constructor Summary
ConstructorDescriptionConstructs a SQLServerDatabaseMetaData database meta data -
Method Summary
Modifier and TypeMethodDescriptionboolean
boolean
boolean
boolean
boolean
boolean
deletesAreDetected
(int type) boolean
boolean
getAttributes
(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) getBestRowIdentifier
(String catalog, String schema, String table, int scope, boolean nullable) getColumnPrivileges
(String catalog, String schema, String table, String col) getColumns
(String catalog, String schema, String table, String col) int
Returns the database compatibility level setting for the current database.int
int
int
int
int
getExportedKeys
(String cat, String schema, String table) getFunctionColumns
(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) getFunctions
(String catalog, String schemaPattern, String functionNamePattern) getImportedKeys
(String cat, String schema, String table) getIndexInfo
(String cat, String schema, String table, boolean unique, boolean approximate) int
int
int
int
int
int
int
int
int
int
int
int
int
int
long
int
int
int
int
int
int
int
int
getPrimaryKeys
(String cat, String schema, String table) getProcedureColumns
(String catalog, String schema, String proc, String col) getProcedures
(String catalog, String schema, String proc) getPseudoColumns
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) int
getSchemas
(String catalog, String schemaPattern) int
getSuperTables
(String catalog, String schemaPattern, String tableNamePattern) getSuperTypes
(String catalog, String schemaPattern, String typeNamePattern) getTablePrivileges
(String catalog, String schema, String table) getURL()
getVersionColumns
(String catalog, String schema, String table) boolean
insertsAreDetected
(int type) boolean
boolean
boolean
isWrapperFor
(Class<?> iface) boolean
boolean
boolean
boolean
boolean
boolean
boolean
othersDeletesAreVisible
(int type) boolean
othersInsertsAreVisible
(int type) boolean
othersUpdatesAreVisible
(int type) boolean
ownDeletesAreVisible
(int type) boolean
ownInsertsAreVisible
(int type) boolean
ownUpdatesAreVisible
(int type) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsConvert
(int fromType, int toType) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsResultSetConcurrency
(int type, int concurrency) boolean
supportsResultSetHoldability
(int holdability) boolean
supportsResultSetType
(int type) boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
boolean
supportsTransactionIsolationLevel
(int level) boolean
boolean
boolean
final String
toString()
Provides a helper function to provide an ID string suitable for tracing.<T> T
boolean
updatesAreDetected
(int type) boolean
boolean
-
Constructor Details
-
SQLServerDatabaseMetaData
Constructs a SQLServerDatabaseMetaData database meta data- Parameters:
con
- the connection
-
-
Method Details
-
toString
Provides a helper function to provide an ID string suitable for tracing. -
isWrapperFor
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
allProceduresAreCallable
- Specified by:
allProceduresAreCallable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
allTablesAreSelectable
- Specified by:
allTablesAreSelectable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
autoCommitFailureClosesAllResultSets
- Specified by:
autoCommitFailureClosesAllResultSets
in interfaceDatabaseMetaData
- Throws:
SQLException
-
dataDefinitionCausesTransactionCommit
- Specified by:
dataDefinitionCausesTransactionCommit
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
dataDefinitionIgnoredInTransactions
- Specified by:
dataDefinitionIgnoredInTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
doesMaxRowSizeIncludeBlobs
- Specified by:
doesMaxRowSizeIncludeBlobs
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
generatedKeyAlwaysReturned
- Specified by:
generatedKeyAlwaysReturned
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxLogicalLobSize
- Specified by:
getMaxLogicalLobSize
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsRefCursors
- Specified by:
supportsRefCursors
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSharding
- Specified by:
supportsSharding
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getCatalogs
- Specified by:
getCatalogs
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getCatalogSeparator
- Specified by:
getCatalogSeparator
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getCatalogTerm
- Specified by:
getCatalogTerm
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getColumnPrivileges
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String col) throws SQLServerException, SQLTimeoutException - Specified by:
getColumnPrivileges
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getTables
public ResultSet getTables(String catalog, String schema, String table, String[] types) throws SQLServerException, SQLTimeoutException - Specified by:
getTables
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getColumns
public ResultSet getColumns(String catalog, String schema, String table, String col) throws SQLException - Specified by:
getColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getFunctions
public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException - Specified by:
getFunctions
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getFunctionColumns
public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException - Specified by:
getFunctionColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getClientInfoProperties
- Specified by:
getClientInfoProperties
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getBestRowIdentifier
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLServerException, SQLTimeoutException - Specified by:
getBestRowIdentifier
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getCrossReference
public ResultSet getCrossReference(String cat1, String schem1, String tab1, String cat2, String schem2, String tab2) throws SQLException, SQLTimeoutException - Specified by:
getCrossReference
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getDatabaseProductName
- Specified by:
getDatabaseProductName
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseProductVersion
- Specified by:
getDatabaseProductVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDefaultTransactionIsolation
- Specified by:
getDefaultTransactionIsolation
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDriverMajorVersion
public int getDriverMajorVersion()- Specified by:
getDriverMajorVersion
in interfaceDatabaseMetaData
-
getDriverMinorVersion
public int getDriverMinorVersion()- Specified by:
getDriverMinorVersion
in interfaceDatabaseMetaData
-
getDriverName
- Specified by:
getDriverName
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDriverVersion
- Specified by:
getDriverVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getExportedKeys
public ResultSet getExportedKeys(String cat, String schema, String table) throws SQLException, SQLTimeoutException - Specified by:
getExportedKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getExtraNameCharacters
- Specified by:
getExtraNameCharacters
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getIdentifierQuoteString
- Specified by:
getIdentifierQuoteString
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getImportedKeys
public ResultSet getImportedKeys(String cat, String schema, String table) throws SQLException, SQLTimeoutException - Specified by:
getImportedKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getIndexInfo
public ResultSet getIndexInfo(String cat, String schema, String table, boolean unique, boolean approximate) throws SQLServerException, SQLTimeoutException - Specified by:
getIndexInfo
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getMaxBinaryLiteralLength
- Specified by:
getMaxBinaryLiteralLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxCatalogNameLength
- Specified by:
getMaxCatalogNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxCharLiteralLength
- Specified by:
getMaxCharLiteralLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnNameLength
- Specified by:
getMaxColumnNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInGroupBy
- Specified by:
getMaxColumnsInGroupBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInIndex
- Specified by:
getMaxColumnsInIndex
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInOrderBy
- Specified by:
getMaxColumnsInOrderBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInSelect
- Specified by:
getMaxColumnsInSelect
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInTable
- Specified by:
getMaxColumnsInTable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxConnections
- Specified by:
getMaxConnections
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getMaxCursorNameLength
- Specified by:
getMaxCursorNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxIndexLength
- Specified by:
getMaxIndexLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxProcedureNameLength
- Specified by:
getMaxProcedureNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxRowSize
- Specified by:
getMaxRowSize
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxSchemaNameLength
- Specified by:
getMaxSchemaNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxStatementLength
- Specified by:
getMaxStatementLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxStatements
- Specified by:
getMaxStatements
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxTableNameLength
- Specified by:
getMaxTableNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxTablesInSelect
- Specified by:
getMaxTablesInSelect
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxUserNameLength
- Specified by:
getMaxUserNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getNumericFunctions
- Specified by:
getNumericFunctions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getPrimaryKeys
public ResultSet getPrimaryKeys(String cat, String schema, String table) throws SQLServerException, SQLTimeoutException - Specified by:
getPrimaryKeys
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getProcedureColumns
public ResultSet getProcedureColumns(String catalog, String schema, String proc, String col) throws SQLServerException, SQLTimeoutException - Specified by:
getProcedureColumns
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getProcedures
public ResultSet getProcedures(String catalog, String schema, String proc) throws SQLServerException, SQLTimeoutException - Specified by:
getProcedures
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getProcedureTerm
- Specified by:
getProcedureTerm
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getPseudoColumns
public ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException - Specified by:
getPseudoColumns
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSchemas
- Specified by:
getSchemas
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getSchemas
- Specified by:
getSchemas
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSchemaTerm
- Specified by:
getSchemaTerm
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSearchStringEscape
- Specified by:
getSearchStringEscape
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSQLKeywords
- Specified by:
getSQLKeywords
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getStringFunctions
- Specified by:
getStringFunctions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSystemFunctions
- Specified by:
getSystemFunctions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getTablePrivileges
public ResultSet getTablePrivileges(String catalog, String schema, String table) throws SQLServerException, SQLTimeoutException - Specified by:
getTablePrivileges
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getTableTypes
- Specified by:
getTableTypes
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getTimeDateFunctions
- Specified by:
getTimeDateFunctions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getTypeInfo
- Specified by:
getTypeInfo
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getURL
- Specified by:
getURL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getUserName
- Specified by:
getUserName
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
getVersionColumns
public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLServerException, SQLTimeoutException - Specified by:
getVersionColumns
in interfaceDatabaseMetaData
- Throws:
SQLServerException
SQLTimeoutException
-
isCatalogAtStart
- Specified by:
isCatalogAtStart
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
isReadOnly
- Specified by:
isReadOnly
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullPlusNonNullIsNull
- Specified by:
nullPlusNonNullIsNull
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedAtEnd
- Specified by:
nullsAreSortedAtEnd
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedAtStart
- Specified by:
nullsAreSortedAtStart
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedHigh
- Specified by:
nullsAreSortedHigh
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedLow
- Specified by:
nullsAreSortedLow
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesLowerCaseIdentifiers
- Specified by:
storesLowerCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesLowerCaseQuotedIdentifiers
- Specified by:
storesLowerCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesMixedCaseIdentifiers
- Specified by:
storesMixedCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesMixedCaseQuotedIdentifiers
- Specified by:
storesMixedCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesUpperCaseIdentifiers
- Specified by:
storesUpperCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesUpperCaseQuotedIdentifiers
- Specified by:
storesUpperCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsAlterTableWithAddColumn
- Specified by:
supportsAlterTableWithAddColumn
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsAlterTableWithDropColumn
- Specified by:
supportsAlterTableWithDropColumn
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92EntryLevelSQL
- Specified by:
supportsANSI92EntryLevelSQL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92FullSQL
- Specified by:
supportsANSI92FullSQL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92IntermediateSQL
- Specified by:
supportsANSI92IntermediateSQL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInDataManipulation
- Specified by:
supportsCatalogsInDataManipulation
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInIndexDefinitions
- Specified by:
supportsCatalogsInIndexDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInPrivilegeDefinitions
- Specified by:
supportsCatalogsInPrivilegeDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInProcedureCalls
- Specified by:
supportsCatalogsInProcedureCalls
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInTableDefinitions
- Specified by:
supportsCatalogsInTableDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsColumnAliasing
- Specified by:
supportsColumnAliasing
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsConvert
- Specified by:
supportsConvert
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsConvert
- Specified by:
supportsConvert
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCoreSQLGrammar
- Specified by:
supportsCoreSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsDataDefinitionAndDataManipulationTransactions
- Specified by:
supportsDataDefinitionAndDataManipulationTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsDataManipulationTransactionsOnly
- Specified by:
supportsDataManipulationTransactionsOnly
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsDifferentTableCorrelationNames
- Specified by:
supportsDifferentTableCorrelationNames
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsExpressionsInOrderBy
- Specified by:
supportsExpressionsInOrderBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsExtendedSQLGrammar
- Specified by:
supportsExtendedSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsFullOuterJoins
- Specified by:
supportsFullOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupBy
- Specified by:
supportsGroupBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupByBeyondSelect
- Specified by:
supportsGroupByBeyondSelect
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsIntegrityEnhancementFacility
- Specified by:
supportsIntegrityEnhancementFacility
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsLikeEscapeClause
- Specified by:
supportsLikeEscapeClause
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsLimitedOuterJoins
- Specified by:
supportsLimitedOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMinimumSQLGrammar
- Specified by:
supportsMinimumSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMixedCaseIdentifiers
- Specified by:
supportsMixedCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMixedCaseQuotedIdentifiers
- Specified by:
supportsMixedCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleResultSets
- Specified by:
supportsMultipleResultSets
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleTransactions
- Specified by:
supportsMultipleTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsNonNullableColumns
- Specified by:
supportsNonNullableColumns
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenCursorsAcrossCommit
- Specified by:
supportsOpenCursorsAcrossCommit
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenCursorsAcrossRollback
- Specified by:
supportsOpenCursorsAcrossRollback
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenStatementsAcrossCommit
- Specified by:
supportsOpenStatementsAcrossCommit
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenStatementsAcrossRollback
- Specified by:
supportsOpenStatementsAcrossRollback
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOuterJoins
- Specified by:
supportsOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsPositionedDelete
- Specified by:
supportsPositionedDelete
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsPositionedUpdate
- Specified by:
supportsPositionedUpdate
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInDataManipulation
- Specified by:
supportsSchemasInDataManipulation
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInIndexDefinitions
- Specified by:
supportsSchemasInIndexDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInPrivilegeDefinitions
- Specified by:
supportsSchemasInPrivilegeDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInProcedureCalls
- Specified by:
supportsSchemasInProcedureCalls
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInTableDefinitions
- Specified by:
supportsSchemasInTableDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSelectForUpdate
- Specified by:
supportsSelectForUpdate
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsStoredProcedures
- Specified by:
supportsStoredProcedures
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInComparisons
- Specified by:
supportsSubqueriesInComparisons
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInExists
- Specified by:
supportsSubqueriesInExists
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInIns
- Specified by:
supportsSubqueriesInIns
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInQuantifieds
- Specified by:
supportsSubqueriesInQuantifieds
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsTableCorrelationNames
- Specified by:
supportsTableCorrelationNames
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsTransactionIsolationLevel
- Specified by:
supportsTransactionIsolationLevel
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsTransactions
- Specified by:
supportsTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsUnion
- Specified by:
supportsUnion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsUnionAll
- Specified by:
supportsUnionAll
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
usesLocalFilePerTable
- Specified by:
usesLocalFilePerTable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
usesLocalFiles
- Specified by:
usesLocalFiles
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsResultSetType
- Specified by:
supportsResultSetType
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsResultSetConcurrency
- Specified by:
supportsResultSetConcurrency
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
ownUpdatesAreVisible
- Specified by:
ownUpdatesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
ownDeletesAreVisible
- Specified by:
ownDeletesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
ownInsertsAreVisible
- Specified by:
ownInsertsAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
othersUpdatesAreVisible
- Specified by:
othersUpdatesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
othersDeletesAreVisible
- Specified by:
othersDeletesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
othersInsertsAreVisible
- Specified by:
othersInsertsAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
updatesAreDetected
- Specified by:
updatesAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
deletesAreDetected
- Specified by:
deletesAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
insertsAreDetected
- Specified by:
insertsAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsBatchUpdates
- Specified by:
supportsBatchUpdates
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getUDTs
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException, SQLTimeoutException - Specified by:
getUDTs
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getConnection
- Specified by:
getConnection
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSQLStateType
- Specified by:
getSQLStateType
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseMajorVersion
- Specified by:
getDatabaseMajorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseMinorVersion
- Specified by:
getDatabaseMinorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getJDBCMajorVersion
- Specified by:
getJDBCMajorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getJDBCMinorVersion
- Specified by:
getJDBCMinorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getResultSetHoldability
- Specified by:
getResultSetHoldability
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getRowIdLifetime
- Specified by:
getRowIdLifetime
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsResultSetHoldability
- Specified by:
supportsResultSetHoldability
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getAttributes
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException, SQLTimeoutException - Specified by:
getAttributes
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getSuperTables
public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException, SQLTimeoutException - Specified by:
getSuperTables
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
getSuperTypes
public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException, SQLTimeoutException - Specified by:
getSuperTypes
in interfaceDatabaseMetaData
- Throws:
SQLException
SQLTimeoutException
-
supportsGetGeneratedKeys
- Specified by:
supportsGetGeneratedKeys
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleOpenResults
- Specified by:
supportsMultipleOpenResults
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsNamedParameters
- Specified by:
supportsNamedParameters
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSavepoints
- Specified by:
supportsSavepoints
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsStatementPooling
- Specified by:
supportsStatementPooling
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsStoredFunctionsUsingCallSyntax
- Specified by:
supportsStoredFunctionsUsingCallSyntax
in interfaceDatabaseMetaData
- Throws:
SQLException
-
locatorsUpdateCopy
- Specified by:
locatorsUpdateCopy
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDatabaseCompatibilityLevel
Returns the database compatibility level setting for the current database. This is useful if the database's compatibility level is lower than the engine version. In this case the database will only support SQL commands at its compatibility level, and not the wider set of commands accepted by the engine.- Returns:
- the database compatibility level value (from sys.databases table).
- Throws:
SQLException
- if error getting compatability level
-