Package com.microsoft.sqlserver.jdbc

Class SQLServerDatabaseMetaData

java.lang.Object

com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData

All Implemented Interfaces:

java.io.Serializable, java.sql.DatabaseMetaData, java.sql.Wrapper

public final class SQLServerDatabaseMetaData
extends java.lang.Object
implements java.sql.DatabaseMetaData, java.io.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

Modifier and Type	Method	Description
boolean	allProceduresAreCallable()
boolean	allTablesAreSelectable()
boolean	autoCommitFailureClosesAllResultSets()
boolean	dataDefinitionCausesTransactionCommit()
boolean	dataDefinitionIgnoredInTransactions()
boolean	deletesAreDetected(int type)
boolean	doesMaxRowSizeIncludeBlobs()
boolean	generatedKeyAlwaysReturned()
java.sql.ResultSet	getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)
java.sql.ResultSet	getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)
java.sql.ResultSet	getCatalogs()
java.lang.String	getCatalogSeparator()
java.lang.String	getCatalogTerm()
java.sql.ResultSet	getClientInfoProperties()
java.sql.ResultSet	getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String col)
java.sql.ResultSet	getColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String col)
java.sql.Connection	getConnection()
java.sql.ResultSet	getCrossReference(java.lang.String cat1, java.lang.String schem1, java.lang.String tab1, java.lang.String cat2, java.lang.String schem2, java.lang.String tab2)
int	getDatabaseCompatibilityLevel()	Returns the database compatibility level setting for the current database.
int	getDatabaseMajorVersion()
int	getDatabaseMinorVersion()
java.lang.String	getDatabaseProductName()
java.lang.String	getDatabaseProductVersion()
int	getDefaultTransactionIsolation()
int	getDriverMajorVersion()
int	getDriverMinorVersion()
java.lang.String	getDriverName()
java.lang.String	getDriverVersion()
java.sql.ResultSet	getExportedKeys(java.lang.String cat, java.lang.String schema, java.lang.String table)
java.lang.String	getExtraNameCharacters()
java.sql.ResultSet	getFunctionColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern, java.lang.String columnNamePattern)
java.sql.ResultSet	getFunctions(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String functionNamePattern)
java.lang.String	getIdentifierQuoteString()
java.sql.ResultSet	getImportedKeys(java.lang.String cat, java.lang.String schema, java.lang.String table)
java.sql.ResultSet	getIndexInfo(java.lang.String cat, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)
int	getJDBCMajorVersion()
int	getJDBCMinorVersion()
int	getMaxBinaryLiteralLength()
int	getMaxCatalogNameLength()
int	getMaxCharLiteralLength()
int	getMaxColumnNameLength()
int	getMaxColumnsInGroupBy()
int	getMaxColumnsInIndex()
int	getMaxColumnsInOrderBy()
int	getMaxColumnsInSelect()
int	getMaxColumnsInTable()
int	getMaxConnections()
int	getMaxCursorNameLength()
int	getMaxIndexLength()
long	getMaxLogicalLobSize()
int	getMaxProcedureNameLength()
int	getMaxRowSize()
int	getMaxSchemaNameLength()
int	getMaxStatementLength()
int	getMaxStatements()
int	getMaxTableNameLength()
int	getMaxTablesInSelect()
int	getMaxUserNameLength()
java.lang.String	getNumericFunctions()
java.sql.ResultSet	getPrimaryKeys(java.lang.String cat, java.lang.String schema, java.lang.String table)
java.sql.ResultSet	getProcedureColumns(java.lang.String catalog, java.lang.String schema, java.lang.String proc, java.lang.String col)
java.sql.ResultSet	getProcedures(java.lang.String catalog, java.lang.String schema, java.lang.String proc)
java.lang.String	getProcedureTerm()
java.sql.ResultSet	getPseudoColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)
int	getResultSetHoldability()
java.sql.RowIdLifetime	getRowIdLifetime()
java.sql.ResultSet	getSchemas()
java.sql.ResultSet	getSchemas(java.lang.String catalog, java.lang.String schemaPattern)
java.lang.String	getSchemaTerm()
java.lang.String	getSearchStringEscape()
java.lang.String	getSQLKeywords()
int	getSQLStateType()
java.lang.String	getStringFunctions()
java.sql.ResultSet	getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)
java.sql.ResultSet	getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)
java.lang.String	getSystemFunctions()
java.sql.ResultSet	getTablePrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table)
java.sql.ResultSet	getTables(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String[] types)
java.sql.ResultSet	getTableTypes()
java.lang.String	getTimeDateFunctions()
java.sql.ResultSet	getTypeInfo()
java.sql.ResultSet	getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types)
java.lang.String	getURL()
java.lang.String	getUserName()
java.sql.ResultSet	getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table)
boolean	insertsAreDetected(int type)
boolean	isCatalogAtStart()
boolean	isReadOnly()
boolean	isWrapperFor(java.lang.Class<?> iface)
boolean	locatorsUpdateCopy()
boolean	nullPlusNonNullIsNull()
boolean	nullsAreSortedAtEnd()
boolean	nullsAreSortedAtStart()
boolean	nullsAreSortedHigh()
boolean	nullsAreSortedLow()
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	storesLowerCaseIdentifiers()
boolean	storesLowerCaseQuotedIdentifiers()
boolean	storesMixedCaseIdentifiers()
boolean	storesMixedCaseQuotedIdentifiers()
boolean	storesUpperCaseIdentifiers()
boolean	storesUpperCaseQuotedIdentifiers()
boolean	supportsAlterTableWithAddColumn()
boolean	supportsAlterTableWithDropColumn()
boolean	supportsANSI92EntryLevelSQL()
boolean	supportsANSI92FullSQL()
boolean	supportsANSI92IntermediateSQL()
boolean	supportsBatchUpdates()
boolean	supportsCatalogsInDataManipulation()
boolean	supportsCatalogsInIndexDefinitions()
boolean	supportsCatalogsInPrivilegeDefinitions()
boolean	supportsCatalogsInProcedureCalls()
boolean	supportsCatalogsInTableDefinitions()
boolean	supportsColumnAliasing()
boolean	supportsConvert()
boolean	supportsConvert(int fromType, int toType)
boolean	supportsCoreSQLGrammar()
boolean	supportsCorrelatedSubqueries()
boolean	supportsDataDefinitionAndDataManipulationTransactions()
boolean	supportsDataManipulationTransactionsOnly()
boolean	supportsDifferentTableCorrelationNames()
boolean	supportsExpressionsInOrderBy()
boolean	supportsExtendedSQLGrammar()
boolean	supportsFullOuterJoins()
boolean	supportsGetGeneratedKeys()
boolean	supportsGroupBy()
boolean	supportsGroupByBeyondSelect()
boolean	supportsGroupByUnrelated()
boolean	supportsIntegrityEnhancementFacility()
boolean	supportsLikeEscapeClause()
boolean	supportsLimitedOuterJoins()
boolean	supportsMinimumSQLGrammar()
boolean	supportsMixedCaseIdentifiers()
boolean	supportsMixedCaseQuotedIdentifiers()
boolean	supportsMultipleOpenResults()
boolean	supportsMultipleResultSets()
boolean	supportsMultipleTransactions()
boolean	supportsNamedParameters()
boolean	supportsNonNullableColumns()
boolean	supportsOpenCursorsAcrossCommit()
boolean	supportsOpenCursorsAcrossRollback()
boolean	supportsOpenStatementsAcrossCommit()
boolean	supportsOpenStatementsAcrossRollback()
boolean	supportsOrderByUnrelated()
boolean	supportsOuterJoins()
boolean	supportsPositionedDelete()
boolean	supportsPositionedUpdate()
boolean	supportsRefCursors()
boolean	supportsResultSetConcurrency(int type, int concurrency)
boolean	supportsResultSetHoldability(int holdability)
boolean	supportsResultSetType(int type)
boolean	supportsSavepoints()
boolean	supportsSchemasInDataManipulation()
boolean	supportsSchemasInIndexDefinitions()
boolean	supportsSchemasInPrivilegeDefinitions()
boolean	supportsSchemasInProcedureCalls()
boolean	supportsSchemasInTableDefinitions()
boolean	supportsSelectForUpdate()
boolean	supportsSharding()
boolean	supportsStatementPooling()
boolean	supportsStoredFunctionsUsingCallSyntax()
boolean	supportsStoredProcedures()
boolean	supportsSubqueriesInComparisons()
boolean	supportsSubqueriesInExists()
boolean	supportsSubqueriesInIns()
boolean	supportsSubqueriesInQuantifieds()
boolean	supportsTableCorrelationNames()
boolean	supportsTransactionIsolationLevel(int level)
boolean	supportsTransactions()
boolean	supportsUnion()
boolean	supportsUnionAll()
java.lang.String	toString()	Provides a helper function to provide an ID string suitable for tracing.
<T> T	unwrap(java.lang.Class<T> iface)
boolean	updatesAreDetected(int type)
boolean	usesLocalFilePerTable()
boolean	usesLocalFiles()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

SQLServerDatabaseMetaData

public SQLServerDatabaseMetaData(SQLServerConnection con)

Constructs a SQLServerDatabaseMetaData database meta data

Parameters:

con - the connection

Method Details

toString

public final java.lang.String toString()

Provides a helper function to provide an ID string suitable for tracing.

Overrides:

toString in class java.lang.Object

Returns:

traceID string

isWrapperFor

public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException

Specified by:

isWrapperFor in interface java.sql.Wrapper

Throws:

java.sql.SQLException

unwrap

public <T> T unwrap(java.lang.Class<T> iface)
             throws java.sql.SQLException

Specified by:

unwrap in interface java.sql.Wrapper

Throws:

java.sql.SQLException

allProceduresAreCallable

public boolean allProceduresAreCallable()
                                 throws SQLServerException

Specified by:

allProceduresAreCallable in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

allTablesAreSelectable

public boolean allTablesAreSelectable()
                               throws SQLServerException

Specified by:

allTablesAreSelectable in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

autoCommitFailureClosesAllResultSets

public boolean autoCommitFailureClosesAllResultSets()
                                             throws java.sql.SQLException

Specified by:

autoCommitFailureClosesAllResultSets in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

dataDefinitionCausesTransactionCommit

public boolean dataDefinitionCausesTransactionCommit()
                                              throws SQLServerException

Specified by:

dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

dataDefinitionIgnoredInTransactions

public boolean dataDefinitionIgnoredInTransactions()
                                            throws SQLServerException

Specified by:

dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

doesMaxRowSizeIncludeBlobs

public boolean doesMaxRowSizeIncludeBlobs()
                                   throws SQLServerException

Specified by:

doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

generatedKeyAlwaysReturned

public boolean generatedKeyAlwaysReturned()
                                   throws java.sql.SQLException

Specified by:

generatedKeyAlwaysReturned in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getMaxLogicalLobSize

public long getMaxLogicalLobSize()
                          throws java.sql.SQLException

Specified by:

getMaxLogicalLobSize in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

supportsRefCursors

public boolean supportsRefCursors()
                           throws java.sql.SQLException

Specified by:

supportsRefCursors in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

supportsSharding

public boolean supportsSharding()
                         throws java.sql.SQLException

Specified by:

supportsSharding in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getCatalogs

public java.sql.ResultSet getCatalogs()
                               throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getCatalogs in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getCatalogSeparator

public java.lang.String getCatalogSeparator()
                                     throws SQLServerException

Specified by:

getCatalogSeparator in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getCatalogTerm

public java.lang.String getCatalogTerm()
                                throws SQLServerException

Specified by:

getCatalogTerm in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getColumnPrivileges

public java.sql.ResultSet getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String col)
                                       throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getColumnPrivileges in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getTables

public java.sql.ResultSet getTables(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String[] types)
                             throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getTables in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getColumns

public java.sql.ResultSet getColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String col)
                              throws java.sql.SQLException

Specified by:

getColumns in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getFunctions

public java.sql.ResultSet getFunctions(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern)
                                throws java.sql.SQLException

Specified by:

getFunctions in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getFunctionColumns

public java.sql.ResultSet getFunctionColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern,
java.lang.String columnNamePattern)
                                      throws java.sql.SQLException

Specified by:

getFunctionColumns in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getClientInfoProperties

public java.sql.ResultSet getClientInfoProperties()
                                           throws java.sql.SQLException

Specified by:

getClientInfoProperties in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getBestRowIdentifier

public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
int scope,
boolean nullable)
                                        throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getBestRowIdentifier in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getCrossReference

public java.sql.ResultSet getCrossReference(java.lang.String cat1,
java.lang.String schem1,
java.lang.String tab1,
java.lang.String cat2,
java.lang.String schem2,
java.lang.String tab2)
                                     throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getCrossReference in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getDatabaseProductName

public java.lang.String getDatabaseProductName()
                                        throws SQLServerException

Specified by:

getDatabaseProductName in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getDatabaseProductVersion

public java.lang.String getDatabaseProductVersion()
                                           throws SQLServerException

Specified by:

getDatabaseProductVersion in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getDefaultTransactionIsolation

public int getDefaultTransactionIsolation()
                                   throws SQLServerException

Specified by:

getDefaultTransactionIsolation in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getDriverMajorVersion

public int getDriverMajorVersion()

Specified by:

getDriverMajorVersion in interface java.sql.DatabaseMetaData

getDriverMinorVersion

public int getDriverMinorVersion()

Specified by:

getDriverMinorVersion in interface java.sql.DatabaseMetaData

getDriverName

public java.lang.String getDriverName()
                               throws SQLServerException

Specified by:

getDriverName in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getDriverVersion

public java.lang.String getDriverVersion()
                                  throws SQLServerException

Specified by:

getDriverVersion in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getExportedKeys

public java.sql.ResultSet getExportedKeys(java.lang.String cat,
java.lang.String schema,
java.lang.String table)
                                   throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getExportedKeys in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getExtraNameCharacters

public java.lang.String getExtraNameCharacters()
                                        throws SQLServerException

Specified by:

getExtraNameCharacters in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getIdentifierQuoteString

public java.lang.String getIdentifierQuoteString()
                                          throws SQLServerException

Specified by:

getIdentifierQuoteString in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getImportedKeys

public java.sql.ResultSet getImportedKeys(java.lang.String cat,
java.lang.String schema,
java.lang.String table)
                                   throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getImportedKeys in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getIndexInfo

public java.sql.ResultSet getIndexInfo(java.lang.String cat,
java.lang.String schema,
java.lang.String table,
boolean unique,
boolean approximate)
                                throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getIndexInfo in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getMaxBinaryLiteralLength

public int getMaxBinaryLiteralLength()
                              throws SQLServerException

Specified by:

getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxCatalogNameLength

public int getMaxCatalogNameLength()
                            throws SQLServerException

Specified by:

getMaxCatalogNameLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxCharLiteralLength

public int getMaxCharLiteralLength()
                            throws SQLServerException

Specified by:

getMaxCharLiteralLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxColumnNameLength

public int getMaxColumnNameLength()
                           throws SQLServerException

Specified by:

getMaxColumnNameLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxColumnsInGroupBy

public int getMaxColumnsInGroupBy()
                           throws SQLServerException

Specified by:

getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxColumnsInIndex

public int getMaxColumnsInIndex()
                         throws SQLServerException

Specified by:

getMaxColumnsInIndex in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxColumnsInOrderBy

public int getMaxColumnsInOrderBy()
                           throws SQLServerException

Specified by:

getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxColumnsInSelect

public int getMaxColumnsInSelect()
                          throws SQLServerException

Specified by:

getMaxColumnsInSelect in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxColumnsInTable

public int getMaxColumnsInTable()
                         throws SQLServerException

Specified by:

getMaxColumnsInTable in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxConnections

public int getMaxConnections()
                      throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getMaxConnections in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getMaxCursorNameLength

public int getMaxCursorNameLength()
                           throws SQLServerException

Specified by:

getMaxCursorNameLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxIndexLength

public int getMaxIndexLength()
                      throws SQLServerException

Specified by:

getMaxIndexLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxProcedureNameLength

public int getMaxProcedureNameLength()
                              throws SQLServerException

Specified by:

getMaxProcedureNameLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxRowSize

public int getMaxRowSize()
                  throws SQLServerException

Specified by:

getMaxRowSize in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxSchemaNameLength

public int getMaxSchemaNameLength()
                           throws SQLServerException

Specified by:

getMaxSchemaNameLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxStatementLength

public int getMaxStatementLength()
                          throws SQLServerException

Specified by:

getMaxStatementLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxStatements

public int getMaxStatements()
                     throws SQLServerException

Specified by:

getMaxStatements in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxTableNameLength

public int getMaxTableNameLength()
                          throws SQLServerException

Specified by:

getMaxTableNameLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxTablesInSelect

public int getMaxTablesInSelect()
                         throws SQLServerException

Specified by:

getMaxTablesInSelect in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getMaxUserNameLength

public int getMaxUserNameLength()
                         throws SQLServerException

Specified by:

getMaxUserNameLength in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getNumericFunctions

public java.lang.String getNumericFunctions()
                                     throws SQLServerException

Specified by:

getNumericFunctions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getPrimaryKeys

public java.sql.ResultSet getPrimaryKeys(java.lang.String cat,
java.lang.String schema,
java.lang.String table)
                                  throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getPrimaryKeys in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getProcedureColumns

public java.sql.ResultSet getProcedureColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String proc,
java.lang.String col)
                                       throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getProcedureColumns in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getProcedures

public java.sql.ResultSet getProcedures(java.lang.String catalog,
java.lang.String schema,
java.lang.String proc)
                                 throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getProcedures in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getProcedureTerm

public java.lang.String getProcedureTerm()
                                  throws SQLServerException

Specified by:

getProcedureTerm in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getPseudoColumns

public java.sql.ResultSet getPseudoColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
                                    throws java.sql.SQLException

Specified by:

getPseudoColumns in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getSchemas

public java.sql.ResultSet getSchemas()
                              throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getSchemas in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getSchemas

public java.sql.ResultSet getSchemas(java.lang.String catalog,
java.lang.String schemaPattern)
                              throws java.sql.SQLException

Specified by:

getSchemas in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getSchemaTerm

public java.lang.String getSchemaTerm()
                               throws SQLServerException

Specified by:

getSchemaTerm in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getSearchStringEscape

public java.lang.String getSearchStringEscape()
                                       throws SQLServerException

Specified by:

getSearchStringEscape in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getSQLKeywords

public java.lang.String getSQLKeywords()
                                throws SQLServerException

Specified by:

getSQLKeywords in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getStringFunctions

public java.lang.String getStringFunctions()
                                    throws SQLServerException

Specified by:

getStringFunctions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getSystemFunctions

public java.lang.String getSystemFunctions()
                                    throws SQLServerException

Specified by:

getSystemFunctions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getTablePrivileges

public java.sql.ResultSet getTablePrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
                                      throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getTablePrivileges in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getTableTypes

public java.sql.ResultSet getTableTypes()
                                 throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getTableTypes in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getTimeDateFunctions

public java.lang.String getTimeDateFunctions()
                                      throws SQLServerException

Specified by:

getTimeDateFunctions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getTypeInfo

public java.sql.ResultSet getTypeInfo()
                               throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getTypeInfo in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getURL

public java.lang.String getURL()
                        throws SQLServerException

Specified by:

getURL in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getUserName

public java.lang.String getUserName()
                             throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getUserName in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

getVersionColumns

public java.sql.ResultSet getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
                                     throws SQLServerException,
java.sql.SQLTimeoutException

Specified by:

getVersionColumns in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

java.sql.SQLTimeoutException

isCatalogAtStart

public boolean isCatalogAtStart()
                         throws SQLServerException

Specified by:

isCatalogAtStart in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

isReadOnly

public boolean isReadOnly()
                   throws SQLServerException

Specified by:

isReadOnly in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

nullPlusNonNullIsNull

public boolean nullPlusNonNullIsNull()
                              throws SQLServerException

Specified by:

nullPlusNonNullIsNull in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

nullsAreSortedAtEnd

public boolean nullsAreSortedAtEnd()
                            throws SQLServerException

Specified by:

nullsAreSortedAtEnd in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

nullsAreSortedAtStart

public boolean nullsAreSortedAtStart()
                              throws SQLServerException

Specified by:

nullsAreSortedAtStart in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

nullsAreSortedHigh

public boolean nullsAreSortedHigh()
                           throws SQLServerException

Specified by:

nullsAreSortedHigh in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

nullsAreSortedLow

public boolean nullsAreSortedLow()
                          throws SQLServerException

Specified by:

nullsAreSortedLow in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

storesLowerCaseIdentifiers

public boolean storesLowerCaseIdentifiers()
                                   throws SQLServerException

Specified by:

storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

storesLowerCaseQuotedIdentifiers

public boolean storesLowerCaseQuotedIdentifiers()
                                         throws SQLServerException

Specified by:

storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

storesMixedCaseIdentifiers

public boolean storesMixedCaseIdentifiers()
                                   throws SQLServerException

Specified by:

storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

storesMixedCaseQuotedIdentifiers

public boolean storesMixedCaseQuotedIdentifiers()
                                         throws SQLServerException

Specified by:

storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

storesUpperCaseIdentifiers

public boolean storesUpperCaseIdentifiers()
                                   throws SQLServerException

Specified by:

storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

storesUpperCaseQuotedIdentifiers

public boolean storesUpperCaseQuotedIdentifiers()
                                         throws SQLServerException

Specified by:

storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsAlterTableWithAddColumn

public boolean supportsAlterTableWithAddColumn()
                                        throws SQLServerException

Specified by:

supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsAlterTableWithDropColumn

public boolean supportsAlterTableWithDropColumn()
                                         throws SQLServerException

Specified by:

supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsANSI92EntryLevelSQL

public boolean supportsANSI92EntryLevelSQL()
                                    throws SQLServerException

Specified by:

supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsANSI92FullSQL

public boolean supportsANSI92FullSQL()
                              throws SQLServerException

Specified by:

supportsANSI92FullSQL in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsANSI92IntermediateSQL

public boolean supportsANSI92IntermediateSQL()
                                      throws SQLServerException

Specified by:

supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsCatalogsInDataManipulation

public boolean supportsCatalogsInDataManipulation()
                                           throws SQLServerException

Specified by:

supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsCatalogsInIndexDefinitions

public boolean supportsCatalogsInIndexDefinitions()
                                           throws SQLServerException

Specified by:

supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsCatalogsInPrivilegeDefinitions

public boolean supportsCatalogsInPrivilegeDefinitions()
                                               throws SQLServerException

Specified by:

supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsCatalogsInProcedureCalls

public boolean supportsCatalogsInProcedureCalls()
                                         throws SQLServerException

Specified by:

supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsCatalogsInTableDefinitions

public boolean supportsCatalogsInTableDefinitions()
                                           throws SQLServerException

Specified by:

supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsColumnAliasing

public boolean supportsColumnAliasing()
                               throws SQLServerException

Specified by:

supportsColumnAliasing in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsConvert

public boolean supportsConvert()
                        throws SQLServerException

Specified by:

supportsConvert in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsConvert

public boolean supportsConvert(int fromType,
int toType)
                        throws SQLServerException

Specified by:

supportsConvert in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsCoreSQLGrammar

public boolean supportsCoreSQLGrammar()
                               throws SQLServerException

Specified by:

supportsCoreSQLGrammar in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsCorrelatedSubqueries

public boolean supportsCorrelatedSubqueries()
                                     throws SQLServerException

Specified by:

supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsDataDefinitionAndDataManipulationTransactions

public boolean supportsDataDefinitionAndDataManipulationTransactions()
                                                              throws SQLServerException

Specified by:

supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsDataManipulationTransactionsOnly

public boolean supportsDataManipulationTransactionsOnly()
                                                 throws SQLServerException

Specified by:

supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsDifferentTableCorrelationNames

public boolean supportsDifferentTableCorrelationNames()
                                               throws SQLServerException

Specified by:

supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsExpressionsInOrderBy

public boolean supportsExpressionsInOrderBy()
                                     throws SQLServerException

Specified by:

supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsExtendedSQLGrammar

public boolean supportsExtendedSQLGrammar()
                                   throws SQLServerException

Specified by:

supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsFullOuterJoins

public boolean supportsFullOuterJoins()
                               throws SQLServerException

Specified by:

supportsFullOuterJoins in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsGroupBy

public boolean supportsGroupBy()
                        throws SQLServerException

Specified by:

supportsGroupBy in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsGroupByBeyondSelect

public boolean supportsGroupByBeyondSelect()
                                    throws SQLServerException

Specified by:

supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsGroupByUnrelated

public boolean supportsGroupByUnrelated()
                                 throws SQLServerException

Specified by:

supportsGroupByUnrelated in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsIntegrityEnhancementFacility

public boolean supportsIntegrityEnhancementFacility()
                                             throws SQLServerException

Specified by:

supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsLikeEscapeClause

public boolean supportsLikeEscapeClause()
                                 throws SQLServerException

Specified by:

supportsLikeEscapeClause in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsLimitedOuterJoins

public boolean supportsLimitedOuterJoins()
                                  throws SQLServerException

Specified by:

supportsLimitedOuterJoins in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsMinimumSQLGrammar

public boolean supportsMinimumSQLGrammar()
                                  throws SQLServerException

Specified by:

supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsMixedCaseIdentifiers

public boolean supportsMixedCaseIdentifiers()
                                     throws SQLServerException

Specified by:

supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsMixedCaseQuotedIdentifiers

public boolean supportsMixedCaseQuotedIdentifiers()
                                           throws SQLServerException

Specified by:

supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsMultipleResultSets

public boolean supportsMultipleResultSets()
                                   throws SQLServerException

Specified by:

supportsMultipleResultSets in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsMultipleTransactions

public boolean supportsMultipleTransactions()
                                     throws SQLServerException

Specified by:

supportsMultipleTransactions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsNonNullableColumns

public boolean supportsNonNullableColumns()
                                   throws SQLServerException

Specified by:

supportsNonNullableColumns in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsOpenCursorsAcrossCommit

public boolean supportsOpenCursorsAcrossCommit()
                                        throws SQLServerException

Specified by:

supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsOpenCursorsAcrossRollback

public boolean supportsOpenCursorsAcrossRollback()
                                          throws SQLServerException

Specified by:

supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsOpenStatementsAcrossCommit

public boolean supportsOpenStatementsAcrossCommit()
                                           throws SQLServerException

Specified by:

supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsOpenStatementsAcrossRollback

public boolean supportsOpenStatementsAcrossRollback()
                                             throws SQLServerException

Specified by:

supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsOrderByUnrelated

public boolean supportsOrderByUnrelated()
                                 throws SQLServerException

Specified by:

supportsOrderByUnrelated in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsOuterJoins

public boolean supportsOuterJoins()
                           throws SQLServerException

Specified by:

supportsOuterJoins in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsPositionedDelete

public boolean supportsPositionedDelete()
                                 throws SQLServerException

Specified by:

supportsPositionedDelete in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsPositionedUpdate

public boolean supportsPositionedUpdate()
                                 throws SQLServerException

Specified by:

supportsPositionedUpdate in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSchemasInDataManipulation

public boolean supportsSchemasInDataManipulation()
                                          throws SQLServerException

Specified by:

supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSchemasInIndexDefinitions

public boolean supportsSchemasInIndexDefinitions()
                                          throws SQLServerException

Specified by:

supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSchemasInPrivilegeDefinitions

public boolean supportsSchemasInPrivilegeDefinitions()
                                              throws SQLServerException

Specified by:

supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSchemasInProcedureCalls

public boolean supportsSchemasInProcedureCalls()
                                        throws SQLServerException

Specified by:

supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSchemasInTableDefinitions

public boolean supportsSchemasInTableDefinitions()
                                          throws SQLServerException

Specified by:

supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSelectForUpdate

public boolean supportsSelectForUpdate()
                                throws SQLServerException

Specified by:

supportsSelectForUpdate in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsStoredProcedures

public boolean supportsStoredProcedures()
                                 throws SQLServerException

Specified by:

supportsStoredProcedures in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSubqueriesInComparisons

public boolean supportsSubqueriesInComparisons()
                                        throws SQLServerException

Specified by:

supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSubqueriesInExists

public boolean supportsSubqueriesInExists()
                                   throws SQLServerException

Specified by:

supportsSubqueriesInExists in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSubqueriesInIns

public boolean supportsSubqueriesInIns()
                                throws SQLServerException

Specified by:

supportsSubqueriesInIns in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSubqueriesInQuantifieds

public boolean supportsSubqueriesInQuantifieds()
                                        throws SQLServerException

Specified by:

supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsTableCorrelationNames

public boolean supportsTableCorrelationNames()
                                      throws SQLServerException

Specified by:

supportsTableCorrelationNames in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsTransactionIsolationLevel

public boolean supportsTransactionIsolationLevel(int level)
                                          throws SQLServerException

Specified by:

supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsTransactions

public boolean supportsTransactions()
                             throws SQLServerException

Specified by:

supportsTransactions in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsUnion

public boolean supportsUnion()
                      throws SQLServerException

Specified by:

supportsUnion in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsUnionAll

public boolean supportsUnionAll()
                         throws SQLServerException

Specified by:

supportsUnionAll in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

usesLocalFilePerTable

public boolean usesLocalFilePerTable()
                              throws SQLServerException

Specified by:

usesLocalFilePerTable in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

usesLocalFiles

public boolean usesLocalFiles()
                       throws SQLServerException

Specified by:

usesLocalFiles in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsResultSetType

public boolean supportsResultSetType(int type)
                              throws SQLServerException

Specified by:

supportsResultSetType in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsResultSetConcurrency

public boolean supportsResultSetConcurrency(int type,
int concurrency)
                                     throws SQLServerException

Specified by:

supportsResultSetConcurrency in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

ownUpdatesAreVisible

public boolean ownUpdatesAreVisible(int type)
                             throws SQLServerException

Specified by:

ownUpdatesAreVisible in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

ownDeletesAreVisible

public boolean ownDeletesAreVisible(int type)
                             throws SQLServerException

Specified by:

ownDeletesAreVisible in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

ownInsertsAreVisible

public boolean ownInsertsAreVisible(int type)
                             throws SQLServerException

Specified by:

ownInsertsAreVisible in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

othersUpdatesAreVisible

public boolean othersUpdatesAreVisible(int type)
                                throws SQLServerException

Specified by:

othersUpdatesAreVisible in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

othersDeletesAreVisible

public boolean othersDeletesAreVisible(int type)
                                throws SQLServerException

Specified by:

othersDeletesAreVisible in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

othersInsertsAreVisible

public boolean othersInsertsAreVisible(int type)
                                throws SQLServerException

Specified by:

othersInsertsAreVisible in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

updatesAreDetected

public boolean updatesAreDetected(int type)
                           throws SQLServerException

Specified by:

updatesAreDetected in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

deletesAreDetected

public boolean deletesAreDetected(int type)
                           throws SQLServerException

Specified by:

deletesAreDetected in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

insertsAreDetected

public boolean insertsAreDetected(int type)
                           throws SQLServerException

Specified by:

insertsAreDetected in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsBatchUpdates

public boolean supportsBatchUpdates()
                             throws SQLServerException

Specified by:

supportsBatchUpdates in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getUDTs

public java.sql.ResultSet getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
                           throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getUDTs in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getConnection

public java.sql.Connection getConnection()
                                  throws SQLServerException

Specified by:

getConnection in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getSQLStateType

public int getSQLStateType()
                    throws SQLServerException

Specified by:

getSQLStateType in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getDatabaseMajorVersion

public int getDatabaseMajorVersion()
                            throws SQLServerException

Specified by:

getDatabaseMajorVersion in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getDatabaseMinorVersion

public int getDatabaseMinorVersion()
                            throws SQLServerException

Specified by:

getDatabaseMinorVersion in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getJDBCMajorVersion

public int getJDBCMajorVersion()
                        throws SQLServerException

Specified by:

getJDBCMajorVersion in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getJDBCMinorVersion

public int getJDBCMinorVersion()
                        throws SQLServerException

Specified by:

getJDBCMinorVersion in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getResultSetHoldability

public int getResultSetHoldability()
                            throws SQLServerException

Specified by:

getResultSetHoldability in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getRowIdLifetime

public java.sql.RowIdLifetime getRowIdLifetime()
                                        throws java.sql.SQLException

Specified by:

getRowIdLifetime in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

supportsResultSetHoldability

public boolean supportsResultSetHoldability(int holdability)
                                     throws SQLServerException

Specified by:

supportsResultSetHoldability in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

getAttributes

public java.sql.ResultSet getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
                                 throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getAttributes in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getSuperTables

public java.sql.ResultSet getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
                                  throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getSuperTables in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

getSuperTypes

public java.sql.ResultSet getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
                                 throws java.sql.SQLException,
java.sql.SQLTimeoutException

Specified by:

getSuperTypes in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

java.sql.SQLTimeoutException

supportsGetGeneratedKeys

public boolean supportsGetGeneratedKeys()
                                 throws SQLServerException

Specified by:

supportsGetGeneratedKeys in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsMultipleOpenResults

public boolean supportsMultipleOpenResults()
                                    throws SQLServerException

Specified by:

supportsMultipleOpenResults in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsNamedParameters

public boolean supportsNamedParameters()
                                throws SQLServerException

Specified by:

supportsNamedParameters in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsSavepoints

public boolean supportsSavepoints()
                           throws SQLServerException

Specified by:

supportsSavepoints in interface java.sql.DatabaseMetaData

Throws:

SQLServerException

supportsStatementPooling

public boolean supportsStatementPooling()
                                 throws java.sql.SQLException

Specified by:

supportsStatementPooling in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

supportsStoredFunctionsUsingCallSyntax

public boolean supportsStoredFunctionsUsingCallSyntax()
                                               throws java.sql.SQLException

Specified by:

supportsStoredFunctionsUsingCallSyntax in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

locatorsUpdateCopy

public boolean locatorsUpdateCopy()
                           throws java.sql.SQLException

Specified by:

locatorsUpdateCopy in interface java.sql.DatabaseMetaData

Throws:

java.sql.SQLException

getDatabaseCompatibilityLevel

public int getDatabaseCompatibilityLevel()
                                  throws java.sql.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:

java.sql.SQLException - if error getting compatability level