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:
- Serialized Form
-
-
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
Constructors Constructor Description SQLServerDatabaseMetaData(SQLServerConnection con)
Constructs a SQLServerDatabaseMetaData database meta data
-
Method Summary
-
-
-
Constructor Detail
-
SQLServerDatabaseMetaData
public SQLServerDatabaseMetaData(SQLServerConnection con)
Constructs a SQLServerDatabaseMetaData database meta data- Parameters:
con
- the connection
-
-
Method Detail
-
toString
public final String toString()
Provides a helper function to provide an ID string suitable for tracing.
-
isWrapperFor
public boolean isWrapperFor(Class<?> iface) throws SQLException
- Specified by:
isWrapperFor
in interfaceWrapper
- Throws:
SQLException
-
unwrap
public <T> T unwrap(Class<T> iface) throws SQLException
- Specified by:
unwrap
in interfaceWrapper
- Throws:
SQLException
-
allProceduresAreCallable
public boolean allProceduresAreCallable() throws SQLServerException
- Specified by:
allProceduresAreCallable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
allTablesAreSelectable
public boolean allTablesAreSelectable() throws SQLServerException
- Specified by:
allTablesAreSelectable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
autoCommitFailureClosesAllResultSets
public boolean autoCommitFailureClosesAllResultSets() throws SQLException
- Specified by:
autoCommitFailureClosesAllResultSets
in interfaceDatabaseMetaData
- Throws:
SQLException
-
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit() throws SQLServerException
- Specified by:
dataDefinitionCausesTransactionCommit
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions() throws SQLServerException
- Specified by:
dataDefinitionIgnoredInTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs() throws SQLServerException
- Specified by:
doesMaxRowSizeIncludeBlobs
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
generatedKeyAlwaysReturned
public boolean generatedKeyAlwaysReturned() throws SQLException
- Specified by:
generatedKeyAlwaysReturned
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxLogicalLobSize
public long getMaxLogicalLobSize() throws SQLException
- Specified by:
getMaxLogicalLobSize
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsRefCursors
public boolean supportsRefCursors() throws SQLException
- Specified by:
supportsRefCursors
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsSharding
public boolean supportsSharding() throws SQLException
- Specified by:
supportsSharding
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getCatalogs
public ResultSet getCatalogs() throws SQLException
- Specified by:
getCatalogs
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getCatalogSeparator
public String getCatalogSeparator() throws SQLServerException
- Specified by:
getCatalogSeparator
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getCatalogTerm
public String getCatalogTerm() throws SQLServerException
- 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
public ResultSet getClientInfoProperties() throws SQLException
- 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
- Specified by:
getCrossReference
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDatabaseProductName
public String getDatabaseProductName() throws SQLServerException
- Specified by:
getDatabaseProductName
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseProductVersion
public String getDatabaseProductVersion() throws SQLServerException
- Specified by:
getDatabaseProductVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation() throws SQLServerException
- 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
public String getDriverName() throws SQLServerException
- Specified by:
getDriverName
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDriverVersion
public String getDriverVersion() throws SQLServerException
- Specified by:
getDriverVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getExportedKeys
public ResultSet getExportedKeys(String cat, String schema, String table) throws SQLException
- Specified by:
getExportedKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getExtraNameCharacters
public String getExtraNameCharacters() throws SQLServerException
- Specified by:
getExtraNameCharacters
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getIdentifierQuoteString
public String getIdentifierQuoteString() throws SQLServerException
- Specified by:
getIdentifierQuoteString
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getImportedKeys
public ResultSet getImportedKeys(String cat, String schema, String table) throws SQLException
- Specified by:
getImportedKeys
in interfaceDatabaseMetaData
- Throws:
SQLException
-
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
public int getMaxBinaryLiteralLength() throws SQLServerException
- Specified by:
getMaxBinaryLiteralLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxCatalogNameLength
public int getMaxCatalogNameLength() throws SQLServerException
- Specified by:
getMaxCatalogNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxCharLiteralLength
public int getMaxCharLiteralLength() throws SQLServerException
- Specified by:
getMaxCharLiteralLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnNameLength
public int getMaxColumnNameLength() throws SQLServerException
- Specified by:
getMaxColumnNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy() throws SQLServerException
- Specified by:
getMaxColumnsInGroupBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInIndex
public int getMaxColumnsInIndex() throws SQLServerException
- Specified by:
getMaxColumnsInIndex
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy() throws SQLServerException
- Specified by:
getMaxColumnsInOrderBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInSelect
public int getMaxColumnsInSelect() throws SQLServerException
- Specified by:
getMaxColumnsInSelect
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxColumnsInTable
public int getMaxColumnsInTable() throws SQLServerException
- Specified by:
getMaxColumnsInTable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxConnections
public int getMaxConnections() throws SQLException
- Specified by:
getMaxConnections
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getMaxCursorNameLength
public int getMaxCursorNameLength() throws SQLServerException
- Specified by:
getMaxCursorNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxIndexLength
public int getMaxIndexLength() throws SQLServerException
- Specified by:
getMaxIndexLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxProcedureNameLength
public int getMaxProcedureNameLength() throws SQLServerException
- Specified by:
getMaxProcedureNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxRowSize
public int getMaxRowSize() throws SQLServerException
- Specified by:
getMaxRowSize
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxSchemaNameLength
public int getMaxSchemaNameLength() throws SQLServerException
- Specified by:
getMaxSchemaNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxStatementLength
public int getMaxStatementLength() throws SQLServerException
- Specified by:
getMaxStatementLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxStatements
public int getMaxStatements() throws SQLServerException
- Specified by:
getMaxStatements
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxTableNameLength
public int getMaxTableNameLength() throws SQLServerException
- Specified by:
getMaxTableNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxTablesInSelect
public int getMaxTablesInSelect() throws SQLServerException
- Specified by:
getMaxTablesInSelect
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getMaxUserNameLength
public int getMaxUserNameLength() throws SQLServerException
- Specified by:
getMaxUserNameLength
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getNumericFunctions
public String getNumericFunctions() throws SQLServerException
- 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
public String getProcedureTerm() throws SQLServerException
- 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
public ResultSet getSchemas() throws SQLException
- Specified by:
getSchemas
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSchemas
public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException
- Specified by:
getSchemas
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSchemaTerm
public String getSchemaTerm() throws SQLServerException
- Specified by:
getSchemaTerm
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSearchStringEscape
public String getSearchStringEscape() throws SQLServerException
- Specified by:
getSearchStringEscape
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSQLKeywords
public String getSQLKeywords() throws SQLServerException
- Specified by:
getSQLKeywords
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getStringFunctions
public String getStringFunctions() throws SQLServerException
- Specified by:
getStringFunctions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSystemFunctions
public String getSystemFunctions() throws SQLServerException
- 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
public ResultSet getTableTypes() throws SQLException
- Specified by:
getTableTypes
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getTimeDateFunctions
public String getTimeDateFunctions() throws SQLServerException
- Specified by:
getTimeDateFunctions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getTypeInfo
public ResultSet getTypeInfo() throws SQLException
- Specified by:
getTypeInfo
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getURL
public String getURL() throws SQLServerException
- Specified by:
getURL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getUserName
public String getUserName() throws SQLServerException, SQLTimeoutException
- 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
public boolean isCatalogAtStart() throws SQLServerException
- Specified by:
isCatalogAtStart
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
isReadOnly
public boolean isReadOnly() throws SQLServerException
- Specified by:
isReadOnly
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull() throws SQLServerException
- Specified by:
nullPlusNonNullIsNull
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd() throws SQLServerException
- Specified by:
nullsAreSortedAtEnd
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart() throws SQLServerException
- Specified by:
nullsAreSortedAtStart
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedHigh
public boolean nullsAreSortedHigh() throws SQLServerException
- Specified by:
nullsAreSortedHigh
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
nullsAreSortedLow
public boolean nullsAreSortedLow() throws SQLServerException
- Specified by:
nullsAreSortedLow
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers() throws SQLServerException
- Specified by:
storesLowerCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers() throws SQLServerException
- Specified by:
storesLowerCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers() throws SQLServerException
- Specified by:
storesMixedCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers() throws SQLServerException
- Specified by:
storesMixedCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers() throws SQLServerException
- Specified by:
storesUpperCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers() throws SQLServerException
- Specified by:
storesUpperCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn() throws SQLServerException
- Specified by:
supportsAlterTableWithAddColumn
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn() throws SQLServerException
- Specified by:
supportsAlterTableWithDropColumn
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL() throws SQLServerException
- Specified by:
supportsANSI92EntryLevelSQL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL() throws SQLServerException
- Specified by:
supportsANSI92FullSQL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL() throws SQLServerException
- Specified by:
supportsANSI92IntermediateSQL
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation() throws SQLServerException
- Specified by:
supportsCatalogsInDataManipulation
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions() throws SQLServerException
- Specified by:
supportsCatalogsInIndexDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLServerException
- Specified by:
supportsCatalogsInPrivilegeDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls() throws SQLServerException
- Specified by:
supportsCatalogsInProcedureCalls
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions() throws SQLServerException
- Specified by:
supportsCatalogsInTableDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsColumnAliasing
public boolean supportsColumnAliasing() throws SQLServerException
- Specified by:
supportsColumnAliasing
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsConvert
public boolean supportsConvert() throws SQLServerException
- Specified by:
supportsConvert
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsConvert
public boolean supportsConvert(int fromType, int toType) throws SQLServerException
- Specified by:
supportsConvert
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar() throws SQLServerException
- Specified by:
supportsCoreSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries() throws SQLServerException
- Specified by:
supportsCorrelatedSubqueries
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLServerException
- Specified by:
supportsDataDefinitionAndDataManipulationTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly() throws SQLServerException
- Specified by:
supportsDataManipulationTransactionsOnly
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames() throws SQLServerException
- Specified by:
supportsDifferentTableCorrelationNames
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy() throws SQLServerException
- Specified by:
supportsExpressionsInOrderBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar() throws SQLServerException
- Specified by:
supportsExtendedSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsFullOuterJoins
public boolean supportsFullOuterJoins() throws SQLServerException
- Specified by:
supportsFullOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupBy
public boolean supportsGroupBy() throws SQLServerException
- Specified by:
supportsGroupBy
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect() throws SQLServerException
- Specified by:
supportsGroupByBeyondSelect
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsGroupByUnrelated
public boolean supportsGroupByUnrelated() throws SQLServerException
- Specified by:
supportsGroupByUnrelated
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility() throws SQLServerException
- Specified by:
supportsIntegrityEnhancementFacility
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause() throws SQLServerException
- Specified by:
supportsLikeEscapeClause
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins() throws SQLServerException
- Specified by:
supportsLimitedOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar() throws SQLServerException
- Specified by:
supportsMinimumSQLGrammar
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers() throws SQLServerException
- Specified by:
supportsMixedCaseIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLServerException
- Specified by:
supportsMixedCaseQuotedIdentifiers
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleResultSets
public boolean supportsMultipleResultSets() throws SQLServerException
- Specified by:
supportsMultipleResultSets
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleTransactions
public boolean supportsMultipleTransactions() throws SQLServerException
- Specified by:
supportsMultipleTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsNonNullableColumns
public boolean supportsNonNullableColumns() throws SQLServerException
- Specified by:
supportsNonNullableColumns
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit() throws SQLServerException
- Specified by:
supportsOpenCursorsAcrossCommit
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback() throws SQLServerException
- Specified by:
supportsOpenCursorsAcrossRollback
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit() throws SQLServerException
- Specified by:
supportsOpenStatementsAcrossCommit
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback() throws SQLServerException
- Specified by:
supportsOpenStatementsAcrossRollback
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOrderByUnrelated
public boolean supportsOrderByUnrelated() throws SQLServerException
- Specified by:
supportsOrderByUnrelated
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsOuterJoins
public boolean supportsOuterJoins() throws SQLServerException
- Specified by:
supportsOuterJoins
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsPositionedDelete
public boolean supportsPositionedDelete() throws SQLServerException
- Specified by:
supportsPositionedDelete
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsPositionedUpdate
public boolean supportsPositionedUpdate() throws SQLServerException
- Specified by:
supportsPositionedUpdate
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation() throws SQLServerException
- Specified by:
supportsSchemasInDataManipulation
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions() throws SQLServerException
- Specified by:
supportsSchemasInIndexDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLServerException
- Specified by:
supportsSchemasInPrivilegeDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls() throws SQLServerException
- Specified by:
supportsSchemasInProcedureCalls
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions() throws SQLServerException
- Specified by:
supportsSchemasInTableDefinitions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSelectForUpdate
public boolean supportsSelectForUpdate() throws SQLServerException
- Specified by:
supportsSelectForUpdate
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsStoredProcedures
public boolean supportsStoredProcedures() throws SQLServerException
- Specified by:
supportsStoredProcedures
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons() throws SQLServerException
- Specified by:
supportsSubqueriesInComparisons
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists() throws SQLServerException
- Specified by:
supportsSubqueriesInExists
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns() throws SQLServerException
- Specified by:
supportsSubqueriesInIns
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds() throws SQLServerException
- Specified by:
supportsSubqueriesInQuantifieds
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames() throws SQLServerException
- Specified by:
supportsTableCorrelationNames
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level) throws SQLServerException
- Specified by:
supportsTransactionIsolationLevel
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsTransactions
public boolean supportsTransactions() throws SQLServerException
- Specified by:
supportsTransactions
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsUnion
public boolean supportsUnion() throws SQLServerException
- Specified by:
supportsUnion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsUnionAll
public boolean supportsUnionAll() throws SQLServerException
- Specified by:
supportsUnionAll
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
usesLocalFilePerTable
public boolean usesLocalFilePerTable() throws SQLServerException
- Specified by:
usesLocalFilePerTable
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
usesLocalFiles
public boolean usesLocalFiles() throws SQLServerException
- Specified by:
usesLocalFiles
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsResultSetType
public boolean supportsResultSetType(int type) throws SQLServerException
- Specified by:
supportsResultSetType
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLServerException
- Specified by:
supportsResultSetConcurrency
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int type) throws SQLServerException
- Specified by:
ownUpdatesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
ownDeletesAreVisible
public boolean ownDeletesAreVisible(int type) throws SQLServerException
- Specified by:
ownDeletesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
ownInsertsAreVisible
public boolean ownInsertsAreVisible(int type) throws SQLServerException
- Specified by:
ownInsertsAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int type) throws SQLServerException
- Specified by:
othersUpdatesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
othersDeletesAreVisible
public boolean othersDeletesAreVisible(int type) throws SQLServerException
- Specified by:
othersDeletesAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
othersInsertsAreVisible
public boolean othersInsertsAreVisible(int type) throws SQLServerException
- Specified by:
othersInsertsAreVisible
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
updatesAreDetected
public boolean updatesAreDetected(int type) throws SQLServerException
- Specified by:
updatesAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
deletesAreDetected
public boolean deletesAreDetected(int type) throws SQLServerException
- Specified by:
deletesAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
insertsAreDetected
public boolean insertsAreDetected(int type) throws SQLServerException
- Specified by:
insertsAreDetected
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsBatchUpdates
public boolean supportsBatchUpdates() throws SQLServerException
- Specified by:
supportsBatchUpdates
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getUDTs
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException
- Specified by:
getUDTs
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getConnection
public Connection getConnection() throws SQLServerException
- Specified by:
getConnection
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getSQLStateType
public int getSQLStateType() throws SQLServerException
- Specified by:
getSQLStateType
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseMajorVersion
public int getDatabaseMajorVersion() throws SQLServerException
- Specified by:
getDatabaseMajorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getDatabaseMinorVersion
public int getDatabaseMinorVersion() throws SQLServerException
- Specified by:
getDatabaseMinorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getJDBCMajorVersion
public int getJDBCMajorVersion() throws SQLServerException
- Specified by:
getJDBCMajorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getJDBCMinorVersion
public int getJDBCMinorVersion() throws SQLServerException
- Specified by:
getJDBCMinorVersion
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getResultSetHoldability
public int getResultSetHoldability() throws SQLServerException
- Specified by:
getResultSetHoldability
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getRowIdLifetime
public RowIdLifetime getRowIdLifetime() throws SQLException
- Specified by:
getRowIdLifetime
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsResultSetHoldability
public boolean supportsResultSetHoldability(int holdability) throws SQLServerException
- Specified by:
supportsResultSetHoldability
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
getAttributes
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException
- Specified by:
getAttributes
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSuperTables
public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException
- Specified by:
getSuperTables
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getSuperTypes
public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException
- Specified by:
getSuperTypes
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsGetGeneratedKeys
public boolean supportsGetGeneratedKeys() throws SQLServerException
- Specified by:
supportsGetGeneratedKeys
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsMultipleOpenResults
public boolean supportsMultipleOpenResults() throws SQLServerException
- Specified by:
supportsMultipleOpenResults
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsNamedParameters
public boolean supportsNamedParameters() throws SQLServerException
- Specified by:
supportsNamedParameters
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsSavepoints
public boolean supportsSavepoints() throws SQLServerException
- Specified by:
supportsSavepoints
in interfaceDatabaseMetaData
- Throws:
SQLServerException
-
supportsStatementPooling
public boolean supportsStatementPooling() throws SQLException
- Specified by:
supportsStatementPooling
in interfaceDatabaseMetaData
- Throws:
SQLException
-
supportsStoredFunctionsUsingCallSyntax
public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException
- Specified by:
supportsStoredFunctionsUsingCallSyntax
in interfaceDatabaseMetaData
- Throws:
SQLException
-
locatorsUpdateCopy
public boolean locatorsUpdateCopy() throws SQLException
- Specified by:
locatorsUpdateCopy
in interfaceDatabaseMetaData
- Throws:
SQLException
-
getDatabaseCompatibilityLevel
public int getDatabaseCompatibilityLevel() throws SQLException
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
-
-