United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 JDBC Driver Documentation

JDBC Driver API Reference

SQLServerDatabaseMetaData Class

SQLServerDatabaseMetaData Methods

allProceduresAreCallable Method (SQLServerDatabaseMetaData)

allTablesAreSelectable Method (SQLServerDatabaseMetaData)

dataDefinitionCausesTransactionCommit Method (SQLServerDatabaseMetaData)

dataDefinitionIgnoredInTransactions Method (SQLServerDatabaseMetaData)

deletesAreDetected Method (SQLServerDatabaseMetaData)

doesMaxRowSizeIncludeBlobs Method (SQLServerDatabaseMetaData)

getAttributes Method (SQLServerDatabaseMetaData)

getBestRowIdentifier Method (SQLServerDatabaseMetaData)

getCatalogs Method (SQLServerDatabaseMetaData)

getCatalogSeparator Method (SQLServerDatabaseMetaData)

getCatalogTerm Method (SQLServerDatabaseMetaData)

getColumnPrivileges Method (SQLServerDatabaseMetaData)

getColumns Method (SQLServerDatabaseMetaData)

getConnection Method (SQLServerDatabaseMetaData)

getCrossReference Method (SQLServerDatabaseMetaData)

getDatabaseMajorVersion Method (SQLServerDatabaseMetaData)

getDatabaseMinorVersion Method (SQLServerDatabaseMetaData)

getDatabaseProductName Method (SQLServerDatabaseMetaData)

getDatabaseProductVersion Method (SQLServerDatabaseMetaData)

getDefaultTransactionIsolation Method (SQLServerDatabaseMetaData)

getDriverMajorVersion Method (SQLServerDatabaseMetaData)

getDriverMinorVersion Method (SQLServerDatabaseMetaData)

getDriverName Method (SQLServerDatabaseMetaData)

getDriverVersion Method (SQLServerDatabaseMetaData)

getExportedKeys Method (SQLServerDatabaseMetaData)

getExtraNameCharacters Method (SQLServerDatabaseMetaData)

getIdentifierQuoteString Method (SQLServerDatabaseMetaData)

getImportedKeys Method (SQLServerDatabaseMetaData)

getIndexInfo Method (SQLServerDatabaseMetaData)

getJDBCMajorVersion Method (SQLServerDatabaseMetaData)

getJDBCMinorVersion Method (SQLServerDatabaseMetaData)

getMaxBinaryLiteralLength Method (SQLServerDatabaseMetaData)

getMaxCatalogNameLength Method (SQLServerDatabaseMetaData)

getMaxCharLiteralLength Method (SQLServerDatabaseMetaData)

getMaxColumnNameLength Method (SQLServerDatabaseMetaData)

getMaxColumnsInGroupBy Method (SQLServerDatabaseMetaData)

getMaxColumnsInIndex Method (SQLServerDatabaseMetaData)

getMaxColumnsInOrderBy Method (SQLServerDatabaseMetaData)

getMaxColumnsInSelect Method (SQLServerDatabaseMetaData)

getMaxColumnsInTable Method (SQLServerDatabaseMetaData)

getMaxConnections Method (SQLServerDatabaseMetaData)

getMaxCursorNameLength Method (SQLServerDatabaseMetaData)

getMaxIndexLength Method (SQLServerDatabaseMetaData)

getMaxProcedureNameLength Method (SQLServerDatabaseMetaData)

getMaxRowSize Method (SQLServerDatabaseMetaData)

getMaxSchemaNameLength Method (SQLServerDatabaseMetaData)

getMaxStatementLength Method (SQLServerDatabaseMetaData)

getMaxStatements Method (SQLServerDatabaseMetaData)

getMaxTableNameLength Method (SQLServerDatabaseMetaData)

getMaxTablesInSelect Method (SQLServerDatabaseMetaData)

getMaxUserNameLength Method (SQLServerDatabaseMetaData)

getNumericFunctions Method (SQLServerDatabaseMetaData)

getPrimaryKeys Method (SQLServerDatabaseMetaData)

getProcedureColumns Method (SQLServerDatabaseMetaData)

getProcedures Method (SQLServerDatabaseMetaData)

getProcedureTerm Method (SQLServerDatabaseMetaData)

getResultSetHoldability Method (SQLServerDatabaseMetaData)

getSchemas Method (SQLServerDatabaseMetaData)

getSchemaTerm Method (SQLServerDatabaseMetaData)

getSearchStringEscape Method (SQLServerDatabaseMetaData)

getSQLKeywords Method (SQLServerDatabaseMetaData)

getSQLStateType Method (SQLServerDatabaseMetaData)

getStringFunctions Method (SQLServerDatabaseMetaData)

getSuperTables Method (SQLServerDatabaseMetaData)

getSuperTypes Method (SQLServerDatabaseMetaData)

getSystemFunctions Method (SQLServerDatabaseMetaData)

getTablePrivileges Method (SQLServerDatabaseMetaData)

getTables Method (SQLServerDatabaseMetaData)

getTableTypes Method (SQLServerDatabaseMetaData)

getTimeDateFunctions Method (SQLServerDatabaseMetaData)

getTypeInfo Method (SQLServerDatabaseMetaData)

getUDTs Method (SQLServerDatabaseMetaData)

getURL Method (SQLServerDatabaseMetaData)

getUserName Method (SQLServerDatabaseMetaData)

getVersionColumns Method (SQLServerDatabaseMetaData)

insertsAreDetected Method (SQLServerDatabaseMetaData)

isCatalogAtStart Method (SQLServerDatabaseMetaData)

isReadOnly Method (SQLServerDatabaseMetaData)

locatorsUpdateCopy Method (SQLServerDatabaseMetaData)

nullPlusNonNullIsNull Method (SQLServerDatabaseMetaData)

nullsAreSortedAtEnd Method (SQLServerDatabaseMetaData)

nullsAreSortedAtStart Method (SQLServerDatabaseMetaData)

nullsAreSortedHigh Method (SQLServerDatabaseMetaData)

nullsAreSortedLow Method (SQLServerDatabaseMetaData)

othersDeletesAreVisible Method (SQLServerDatabaseMetaData)

othersInsertsAreVisible Method (SQLServerDatabaseMetaData)

othersUpdatesAreVisible Method (SQLServerDatabaseMetaData)

ownDeletesAreVisible Method (SQLServerDatabaseMetaData)

ownInsertsAreVisible Method (SQLServerDatabaseMetaData)

ownUpdatesAreVisible Method (SQLServerDatabaseMetaData)

storesLowerCaseIdentifiers Method (SQLServerDatabaseMetaData)

storesLowerCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

storesMixedCaseIdentifiers Method (SQLServerDatabaseMetaData)

storesMixedCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

storesUpperCaseIdentifiers Method (SQLServerDatabaseMetaData)

storesUpperCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

supportsAlterTableWithAddColumn Method (SQLServerDatabaseMetaData)

supportsAlterTableWithDropColumn Method (SQLServerDatabaseMetaData)

supportsANSI92EntryLevelSQL Method (SQLServerDatabaseMetaData)

supportsANSI92FullSQL Method (SQLServerDatabaseMetaData)

supportsANSI92IntermediateSQL Method (SQLServerDatabaseMetaData)

supportsBatchUpdates Method (SQLServerDatabaseMetaData)

supportsCatalogsInDataManipulation Method (SQLServerDatabaseMetaData)

supportsCatalogsInIndexDefinitions Method (SQLServerDatabaseMetaData)

supportsCatalogsInPrivilegeDefinitions Method (SQLServerDatabaseMetaData)

supportsCatalogsInProcedureCalls Method (SQLServerDatabaseMetaData)

supportsCatalogsInTableDefinitions Method (SQLServerDatabaseMetaData)

supportsColumnAliasing Method (SQLServerDatabaseMetaData)

supportsConvert Method (SQLServerDatabaseMetaData)

supportsCoreSQLGrammar Method (SQLServerDatabaseMetaData)

supportsCorrelatedSubqueries Method (SQLServerDatabaseMetaData)

supportsDataDefinitionAndDataManipulationTransactions Method (SQLServerDatabaseMetaData)

supportsDataManipulationTransactionsOnly Method (SQLServerDatabaseMetaData)

supportsDifferentTableCorrelationNames Method (SQLServerDatabaseMetaData)

supportsExpressionsInOrderBy Method (SQLServerDatabaseMetaData)

supportsExtendedSQLGrammar Method (SQLServerDatabaseMetaData)

supportsFullOuterJoins Method (SQLServerDatabaseMetaData)

supportsGetGeneratedKeys Method (SQLServerDatabaseMetaData)

supportsGroupBy Method (SQLServerDatabaseMetaData)

supportsGroupByBeyondSelect Method (SQLServerDatabaseMetaData)

supportsGroupByUnrelated Method (SQLServerDatabaseMetaData)

supportsIntegrityEnhancementFacility Method (SQLServerDatabaseMetaData)

supportsLikeEscapeClause Method (SQLServerDatabaseMetaData)

supportsLimitedOuterJoins Method (SQLServerDatabaseMetaData)

supportsMinimumSQLGrammar Method (SQLServerDatabaseMetaData)

supportsMixedCaseIdentifiers Method (SQLServerDatabaseMetaData)

supportsMixedCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)

supportsMultipleOpenResults Method (SQLServerDatabaseMetaData)

supportsMultipleResultSets Method (SQLServerDatabaseMetaData)

supportsMultipleTransactions Method (SQLServerDatabaseMetaData)

supportsNamedParameters Method (SQLServerDatabaseMetaData)

supportsNonNullableColumns Method (SQLServerDatabaseMetaData)

supportsOpenCursorsAcrossCommit Method (SQLServerDatabaseMetaData)

supportsOpenCursorsAcrossRollback Method (SQLServerDatabaseMetaData)

supportsOpenStatementsAcrossCommit Method (SQLServerDatabaseMetaData)

supportsOpenStatementsAcrossRollback Method (SQLServerDatabaseMetaData)

supportsOrderByUnrelated Method (SQLServerDatabaseMetaData)

supportsOuterJoins Method (SQLServerDatabaseMetaData)

supportsPositionedDelete Method (SQLServerDatabaseMetaData)

supportsPositionedUpdate Method (SQLServerDatabaseMetaData)

supportsResultSetConcurrency Method (SQLServerDatabaseMetaData)

supportsResultSetHoldability Method (SQLServerDatabaseMetaData)

supportsResultSetType Method (SQLServerDatabaseMetaData)

supportsSavepoints Method (SQLServerDatabaseMetaData)

supportsSchemasInDataManipulation Method (SQLServerDatabaseMetaData)

supportsSchemasInIndexDefinitions Method (SQLServerDatabaseMetaData)

supportsSchemasInPrivilegeDefinitions Method (SQLServerDatabaseMetaData)

supportsSchemasInProcedureCalls Method (SQLServerDatabaseMetaData)

supportsSchemasInTableDefinitions Method (SQLServerDatabaseMetaData)

supportsSelectForUpdate Method (SQLServerDatabaseMetaData)

supportsStatementPooling Method (SQLServerDatabaseMetaData)

supportsStoredProcedures Method (SQLServerDatabaseMetaData)

supportsSubqueriesInComparisons Method (SQLServerDatabaseMetaData)

supportsSubqueriesInExists Method (SQLServerDatabaseMetaData)

supportsSubqueriesInIns Method (SQLServerDatabaseMetaData)

supportsSubqueriesInQuantifieds Method (SQLServerDatabaseMetaData)

supportsTableCorrelationNames Method (SQLServerDatabaseMetaData)

supportsTransactionIsolationLevel Method (SQLServerDatabaseMetaData)

supportsTransactions Method (SQLServerDatabaseMetaData)

supportsUnion Method (SQLServerDatabaseMetaData)

supportsUnionAll Method (SQLServerDatabaseMetaData)

updatesAreDetected Method (SQLServerDatabaseMetaData)

usesLocalFilePerTable Method (SQLServerDatabaseMetaData)

usesLocalFiles Method (SQLServerDatabaseMetaData)

Minimize

This topic has not yet been rated - Rate this topic

supportsOrderByUnrelated Method (SQLServerDatabaseMetaData)

SQL Server 2005

Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.


public boolean supportsOrderByUnrelated()

true if supported. Otherwise, false.

SQLServerException

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

Reference

SQLServerDatabaseMetaData Class

Concepts

SQLServerDatabaseMetaData Methods
SQLServerDatabaseMetaData Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.