java.sql.DatabaseMetaData, java.sql.Wrapperpublic final class SQLServerDatabaseMetaData
extends java.lang.Object
implements 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 | Description |
|---|---|
SQLServerDatabaseMetaData(SQLServerConnection con) |
Create new database meta data
|
| 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 |
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() |
This is 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() |
public SQLServerDatabaseMetaData(SQLServerConnection con)
con - the connectionpublic final java.lang.String toString()
toString in class java.lang.Objectpublic boolean isWrapperFor(java.lang.Class<?> iface)
throws java.sql.SQLException
isWrapperFor in interface java.sql.Wrapperjava.sql.SQLExceptionpublic <T> T unwrap(java.lang.Class<T> iface)
throws java.sql.SQLException
unwrap in interface java.sql.Wrapperjava.sql.SQLExceptionpublic boolean allProceduresAreCallable()
throws SQLServerException
allProceduresAreCallable in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean allTablesAreSelectable()
throws SQLServerException
allTablesAreSelectable in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean autoCommitFailureClosesAllResultSets()
throws java.sql.SQLException
autoCommitFailureClosesAllResultSets in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean dataDefinitionCausesTransactionCommit()
throws SQLServerException
dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean dataDefinitionIgnoredInTransactions()
throws SQLServerException
dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean doesMaxRowSizeIncludeBlobs()
throws SQLServerException
doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean generatedKeyAlwaysReturned()
throws java.sql.SQLException
generatedKeyAlwaysReturned in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic long getMaxLogicalLobSize()
throws java.sql.SQLException
getMaxLogicalLobSize in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsRefCursors()
throws java.sql.SQLException
supportsRefCursors in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsSharding()
throws java.sql.SQLException
supportsSharding in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.sql.ResultSet getCatalogs()
throws SQLServerException,
java.sql.SQLTimeoutException
getCatalogs in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.lang.String getCatalogSeparator()
throws SQLServerException
getCatalogSeparator in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getCatalogTerm()
throws SQLServerException
getCatalogTerm in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic 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
getColumnPrivileges in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic 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
getTables in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table,
java.lang.String col)
throws SQLServerException,
java.sql.SQLTimeoutException
getColumns in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getFunctions(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern)
throws java.sql.SQLException
getFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.sql.ResultSet getFunctionColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String functionNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getFunctionColumns in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.sql.ResultSet getClientInfoProperties()
throws java.sql.SQLException
getClientInfoProperties in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic 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
getBestRowIdentifier in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic 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 SQLServerException,
java.sql.SQLTimeoutException
getCrossReference in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.lang.String getDatabaseProductName()
throws SQLServerException
getDatabaseProductName in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getDatabaseProductVersion()
throws SQLServerException
getDatabaseProductVersion in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getDefaultTransactionIsolation()
throws SQLServerException
getDefaultTransactionIsolation in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getDriverMajorVersion()
getDriverMajorVersion in interface java.sql.DatabaseMetaDatapublic int getDriverMinorVersion()
getDriverMinorVersion in interface java.sql.DatabaseMetaDatapublic java.lang.String getDriverName()
throws SQLServerException
getDriverName in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getDriverVersion()
throws SQLServerException
getDriverVersion in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getExportedKeys(java.lang.String cat,
java.lang.String schema,
java.lang.String table)
throws SQLServerException,
java.sql.SQLTimeoutException
getExportedKeys in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.lang.String getExtraNameCharacters()
throws SQLServerException
getExtraNameCharacters in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getIdentifierQuoteString()
throws SQLServerException
getIdentifierQuoteString in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getImportedKeys(java.lang.String cat,
java.lang.String schema,
java.lang.String table)
throws SQLServerException,
java.sql.SQLTimeoutException
getImportedKeys in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic 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
getIndexInfo in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic int getMaxBinaryLiteralLength()
throws SQLServerException
getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxCatalogNameLength()
throws SQLServerException
getMaxCatalogNameLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxCharLiteralLength()
throws SQLServerException
getMaxCharLiteralLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxColumnNameLength()
throws SQLServerException
getMaxColumnNameLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxColumnsInGroupBy()
throws SQLServerException
getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxColumnsInIndex()
throws SQLServerException
getMaxColumnsInIndex in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxColumnsInOrderBy()
throws SQLServerException
getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxColumnsInSelect()
throws SQLServerException
getMaxColumnsInSelect in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxColumnsInTable()
throws SQLServerException
getMaxColumnsInTable in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxConnections()
throws SQLServerException,
java.sql.SQLTimeoutException
getMaxConnections in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic int getMaxCursorNameLength()
throws SQLServerException
getMaxCursorNameLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxIndexLength()
throws SQLServerException
getMaxIndexLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxProcedureNameLength()
throws SQLServerException
getMaxProcedureNameLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxRowSize()
throws SQLServerException
getMaxRowSize in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxSchemaNameLength()
throws SQLServerException
getMaxSchemaNameLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxStatementLength()
throws SQLServerException
getMaxStatementLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxStatements()
throws SQLServerException
getMaxStatements in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxTableNameLength()
throws SQLServerException
getMaxTableNameLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxTablesInSelect()
throws SQLServerException
getMaxTablesInSelect in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getMaxUserNameLength()
throws SQLServerException
getMaxUserNameLength in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getNumericFunctions()
throws SQLServerException
getNumericFunctions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getPrimaryKeys(java.lang.String cat,
java.lang.String schema,
java.lang.String table)
throws SQLServerException,
java.sql.SQLTimeoutException
getPrimaryKeys in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic 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
getProcedureColumns in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getProcedures(java.lang.String catalog,
java.lang.String schema,
java.lang.String proc)
throws SQLServerException,
java.sql.SQLTimeoutException
getProcedures in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.lang.String getProcedureTerm()
throws SQLServerException
getProcedureTerm in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getPseudoColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getPseudoColumns in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.sql.ResultSet getSchemas()
throws SQLServerException,
java.sql.SQLTimeoutException
getSchemas in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getSchemas(java.lang.String catalog,
java.lang.String schemaPattern)
throws java.sql.SQLException
getSchemas in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getSchemaTerm()
throws SQLServerException
getSchemaTerm in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getSearchStringEscape()
throws SQLServerException
getSearchStringEscape in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getSQLKeywords()
throws SQLServerException
getSQLKeywords in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getStringFunctions()
throws SQLServerException
getStringFunctions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getSystemFunctions()
throws SQLServerException
getSystemFunctions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getTablePrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws SQLServerException,
java.sql.SQLTimeoutException
getTablePrivileges in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getTableTypes()
throws SQLServerException,
java.sql.SQLTimeoutException
getTableTypes in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.lang.String getTimeDateFunctions()
throws SQLServerException
getTimeDateFunctions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getTypeInfo()
throws SQLServerException,
java.sql.SQLTimeoutException
getTypeInfo in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.lang.String getURL()
throws SQLServerException
getURL in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.lang.String getUserName()
throws SQLServerException,
java.sql.SQLTimeoutException
getUserName in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String table)
throws SQLServerException,
java.sql.SQLTimeoutException
getVersionColumns in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic boolean isCatalogAtStart()
throws SQLServerException
isCatalogAtStart in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean isReadOnly()
throws SQLServerException
isReadOnly in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean nullPlusNonNullIsNull()
throws SQLServerException
nullPlusNonNullIsNull in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean nullsAreSortedAtEnd()
throws SQLServerException
nullsAreSortedAtEnd in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean nullsAreSortedAtStart()
throws SQLServerException
nullsAreSortedAtStart in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean nullsAreSortedHigh()
throws SQLServerException
nullsAreSortedHigh in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean nullsAreSortedLow()
throws SQLServerException
nullsAreSortedLow in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean storesLowerCaseIdentifiers()
throws SQLServerException
storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean storesLowerCaseQuotedIdentifiers()
throws SQLServerException
storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean storesMixedCaseIdentifiers()
throws SQLServerException
storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean storesMixedCaseQuotedIdentifiers()
throws SQLServerException
storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean storesUpperCaseIdentifiers()
throws SQLServerException
storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean storesUpperCaseQuotedIdentifiers()
throws SQLServerException
storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsAlterTableWithAddColumn()
throws SQLServerException
supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsAlterTableWithDropColumn()
throws SQLServerException
supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsANSI92EntryLevelSQL()
throws SQLServerException
supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsANSI92FullSQL()
throws SQLServerException
supportsANSI92FullSQL in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsANSI92IntermediateSQL()
throws SQLServerException
supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsCatalogsInDataManipulation()
throws SQLServerException
supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsCatalogsInIndexDefinitions()
throws SQLServerException
supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsCatalogsInPrivilegeDefinitions()
throws SQLServerException
supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsCatalogsInProcedureCalls()
throws SQLServerException
supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsCatalogsInTableDefinitions()
throws SQLServerException
supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsColumnAliasing()
throws SQLServerException
supportsColumnAliasing in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsConvert()
throws SQLServerException
supportsConvert in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsConvert(int fromType,
int toType)
throws SQLServerException
supportsConvert in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsCoreSQLGrammar()
throws SQLServerException
supportsCoreSQLGrammar in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsCorrelatedSubqueries()
throws SQLServerException
supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsDataDefinitionAndDataManipulationTransactions()
throws SQLServerException
supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsDataManipulationTransactionsOnly()
throws SQLServerException
supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsDifferentTableCorrelationNames()
throws SQLServerException
supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsExpressionsInOrderBy()
throws SQLServerException
supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsExtendedSQLGrammar()
throws SQLServerException
supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsFullOuterJoins()
throws SQLServerException
supportsFullOuterJoins in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsGroupBy()
throws SQLServerException
supportsGroupBy in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsGroupByBeyondSelect()
throws SQLServerException
supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsGroupByUnrelated()
throws SQLServerException
supportsGroupByUnrelated in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsIntegrityEnhancementFacility()
throws SQLServerException
supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsLikeEscapeClause()
throws SQLServerException
supportsLikeEscapeClause in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsLimitedOuterJoins()
throws SQLServerException
supportsLimitedOuterJoins in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsMinimumSQLGrammar()
throws SQLServerException
supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsMixedCaseIdentifiers()
throws SQLServerException
supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsMixedCaseQuotedIdentifiers()
throws SQLServerException
supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsMultipleResultSets()
throws SQLServerException
supportsMultipleResultSets in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsMultipleTransactions()
throws SQLServerException
supportsMultipleTransactions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsNonNullableColumns()
throws SQLServerException
supportsNonNullableColumns in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsOpenCursorsAcrossCommit()
throws SQLServerException
supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsOpenCursorsAcrossRollback()
throws SQLServerException
supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsOpenStatementsAcrossCommit()
throws SQLServerException
supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsOpenStatementsAcrossRollback()
throws SQLServerException
supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsOrderByUnrelated()
throws SQLServerException
supportsOrderByUnrelated in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsOuterJoins()
throws SQLServerException
supportsOuterJoins in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsPositionedDelete()
throws SQLServerException
supportsPositionedDelete in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsPositionedUpdate()
throws SQLServerException
supportsPositionedUpdate in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSchemasInDataManipulation()
throws SQLServerException
supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSchemasInIndexDefinitions()
throws SQLServerException
supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSchemasInPrivilegeDefinitions()
throws SQLServerException
supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSchemasInProcedureCalls()
throws SQLServerException
supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSchemasInTableDefinitions()
throws SQLServerException
supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSelectForUpdate()
throws SQLServerException
supportsSelectForUpdate in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsStoredProcedures()
throws SQLServerException
supportsStoredProcedures in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSubqueriesInComparisons()
throws SQLServerException
supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSubqueriesInExists()
throws SQLServerException
supportsSubqueriesInExists in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSubqueriesInIns()
throws SQLServerException
supportsSubqueriesInIns in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSubqueriesInQuantifieds()
throws SQLServerException
supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsTableCorrelationNames()
throws SQLServerException
supportsTableCorrelationNames in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsTransactionIsolationLevel(int level)
throws SQLServerException
supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsTransactions()
throws SQLServerException
supportsTransactions in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsUnion()
throws SQLServerException
supportsUnion in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsUnionAll()
throws SQLServerException
supportsUnionAll in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean usesLocalFilePerTable()
throws SQLServerException
usesLocalFilePerTable in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean usesLocalFiles()
throws SQLServerException
usesLocalFiles in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsResultSetType(int type)
throws SQLServerException
supportsResultSetType in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsResultSetConcurrency(int type,
int concurrency)
throws SQLServerException
supportsResultSetConcurrency in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean ownUpdatesAreVisible(int type)
throws SQLServerException
ownUpdatesAreVisible in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean ownDeletesAreVisible(int type)
throws SQLServerException
ownDeletesAreVisible in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean ownInsertsAreVisible(int type)
throws SQLServerException
ownInsertsAreVisible in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean othersUpdatesAreVisible(int type)
throws SQLServerException
othersUpdatesAreVisible in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean othersDeletesAreVisible(int type)
throws SQLServerException
othersDeletesAreVisible in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean othersInsertsAreVisible(int type)
throws SQLServerException
othersInsertsAreVisible in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean updatesAreDetected(int type)
throws SQLServerException
updatesAreDetected in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean deletesAreDetected(int type)
throws SQLServerException
deletesAreDetected in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean insertsAreDetected(int type)
throws SQLServerException
insertsAreDetected in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsBatchUpdates()
throws SQLServerException
supportsBatchUpdates in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
throws SQLServerException,
java.sql.SQLTimeoutException
getUDTs in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.Connection getConnection()
throws SQLServerException
getConnection in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getSQLStateType()
throws SQLServerException
getSQLStateType in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getDatabaseMajorVersion()
throws SQLServerException
getDatabaseMajorVersion in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getDatabaseMinorVersion()
throws SQLServerException
getDatabaseMinorVersion in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getJDBCMajorVersion()
throws SQLServerException
getJDBCMajorVersion in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getJDBCMinorVersion()
throws SQLServerException
getJDBCMinorVersion in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic int getResultSetHoldability()
throws SQLServerException
getResultSetHoldability in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.RowIdLifetime getRowIdLifetime()
throws java.sql.SQLException
getRowIdLifetime in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsResultSetHoldability(int holdability)
throws SQLServerException
supportsResultSetHoldability in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic java.sql.ResultSet getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
throws SQLServerException,
java.sql.SQLTimeoutException
getAttributes in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
throws SQLServerException,
java.sql.SQLTimeoutException
getSuperTables in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic java.sql.ResultSet getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
throws SQLServerException,
java.sql.SQLTimeoutException
getSuperTypes in interface java.sql.DatabaseMetaDataSQLServerExceptionjava.sql.SQLTimeoutExceptionpublic boolean supportsGetGeneratedKeys()
throws SQLServerException
supportsGetGeneratedKeys in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsMultipleOpenResults()
throws SQLServerException
supportsMultipleOpenResults in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsNamedParameters()
throws SQLServerException
supportsNamedParameters in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsSavepoints()
throws SQLServerException
supportsSavepoints in interface java.sql.DatabaseMetaDataSQLServerExceptionpublic boolean supportsStatementPooling()
throws java.sql.SQLException
supportsStatementPooling in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsStoredFunctionsUsingCallSyntax()
throws java.sql.SQLException
supportsStoredFunctionsUsingCallSyntax in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean locatorsUpdateCopy()
throws java.sql.SQLException
locatorsUpdateCopy in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionCopyright © 2018 Microsoft Corporation. All rights reserved.