SqlServerDatabaseMetaData
class in package klyn.databases.sql.sqlserver

    public class SqlServerDatabaseMetaData implements DatabaseMetaData:

SqlServerDatabaseMetaData
All Implemented Interfaces: DatabaseMetaData

Database metadata for SQL Server.

Properties

Modifier and Type | Member | Description
--- | --- | ---
public readonly property | connection `connection as Connection:` | No summary.
public readonly property | dataDefinitionCausesTransactionCommit `dataDefinitionCausesTransactionCommit as Boolean:` | No summary.
public readonly property | dataDefinitionIgnoredInTransactions `dataDefinitionIgnoredInTransactions as Boolean:` | No summary.
public readonly property | dateTimeFunctions `dateTimeFunctions as String:` | No summary.
public readonly property | driverMajorVersion `driverMajorVersion as Int:` | No summary.
public readonly property | driverMinorVersion `driverMinorVersion as Int:` | No summary.
public readonly property | driverName `driverName as String:` | No summary.
public readonly property | driverVersion `driverVersion as String:` | No summary.
public readonly property | extraNameCharacters `extraNameCharacters as String:` | No summary.
public readonly property | identifierQuoteString `identifierQuoteString as String:` | No summary.
public readonly property | nullPlusNonNullIsNull `nullPlusNonNullIsNull as Boolean:` | No summary.
public readonly property | numericFunctions `numericFunctions as String:` | No summary.
public readonly property | productName `productName as String:` | No summary.
public readonly property | productVersion `productVersion as String:` | No summary.
public readonly property | readOnly `readOnly as Boolean:` | No summary.
public readonly property | searchStringEscape `searchStringEscape as String:` | No summary.
public readonly property | sqlKeywords `sqlKeywords as String:` | No summary.
public readonly property | storesLowerCaseIdentifiers `storesLowerCaseIdentifiers as Boolean:` | No summary.
public readonly property | storesLowerCaseQuotedIdentifiers `storesLowerCaseQuotedIdentifiers as Boolean:` | No summary.
public readonly property | storesMixedCaseIdentifiers `storesMixedCaseIdentifiers as Boolean:` | No summary.
public readonly property | storesMixedCaseQuotedIdentifiers `storesMixedCaseQuotedIdentifiers as Boolean:` | No summary.
public readonly property | storesUpperCaseIdentifiers `storesUpperCaseIdentifiers as Boolean:` | No summary.
public readonly property | storesUpperCaseQuotedIdentifiers `storesUpperCaseQuotedIdentifiers as Boolean:` | No summary.
public readonly property | stringFunctions `stringFunctions as String:` | No summary.
public readonly property | supportsANSI92EntryLevelSQL `supportsANSI92EntryLevelSQL as Boolean:` | No summary.
public readonly property | supportsANSI92FullSQL `supportsANSI92FullSQL as Boolean:` | No summary.
public readonly property | supportsANSI92IntermediateSQL `supportsANSI92IntermediateSQL as Boolean:` | No summary.
public readonly property | supportsAlterTableWithAddColumn `supportsAlterTableWithAddColumn as Boolean:` | No summary.
public readonly property | supportsAlterTableWithDropColumn `supportsAlterTableWithDropColumn as Boolean:` | No summary.
public readonly property | supportsBatchUpdates `supportsBatchUpdates as Boolean:` | No summary.
public readonly property | supportsCatalogsInDataManipulation `supportsCatalogsInDataManipulation as Boolean:` | No summary.
public readonly property | supportsCatalogsInIndexDefinitions `supportsCatalogsInIndexDefinitions as Boolean:` | No summary.
public readonly property | supportsCatalogsInPrivilegeDefinitions `supportsCatalogsInPrivilegeDefinitions as Boolean:` | No summary.
public readonly property | supportsCatalogsInProcedureCalls `supportsCatalogsInProcedureCalls as Boolean:` | No summary.
public readonly property | supportsCatalogsInTableDefinitions `supportsCatalogsInTableDefinitions as Boolean:` | No summary.
public readonly property | supportsColumnAliasing `supportsColumnAliasing as Boolean:` | No summary.
public readonly property | supportsConvert `supportsConvert as Boolean:` | No summary.
public readonly property | supportsCoreSQLGrammar `supportsCoreSQLGrammar as Boolean:` | No summary.
public readonly property | supportsCorrelatedSubqueries `supportsCorrelatedSubqueries as Boolean:` | No summary.
public readonly property | supportsDataDefinitionAndDataManipulationTransactions `supportsDataDefinitionAndDataManipulationTransactions as Boolean:` | No summary.
public readonly property | supportsDataManipulationTransactionsOnly `supportsDataManipulationTransactionsOnly as Boolean:` | No summary.
public readonly property | supportsDifferentTableCorrelationNames `supportsDifferentTableCorrelationNames as Boolean:` | No summary.
public readonly property | supportsExpressionsInOrderBy `supportsExpressionsInOrderBy as Boolean:` | No summary.
public readonly property | supportsExtendedSQLGrammar `supportsExtendedSQLGrammar as Boolean:` | No summary.
public readonly property | supportsFullOuterJoins `supportsFullOuterJoins as Boolean:` | No summary.
public readonly property | supportsGroupBy `supportsGroupBy as Boolean:` | No summary.
public readonly property | supportsGroupByBeyondSelect `supportsGroupByBeyondSelect as Boolean:` | No summary.
public readonly property | supportsGroupByUnrelated `supportsGroupByUnrelated as Boolean:` | No summary.
public readonly property | supportsIntegrityEnhancementFacility `supportsIntegrityEnhancementFacility as Boolean:` | No summary.
public readonly property | supportsLikeEscapeClause `supportsLikeEscapeClause as Boolean:` | No summary.
public readonly property | supportsMinimumSQLGrammar `supportsMinimumSQLGrammar as Boolean:` | No summary.
public readonly property | supportsMixedCaseIdentifiers `supportsMixedCaseIdentifiers as Boolean:` | No summary.
public readonly property | supportsMixedCaseQuotedIdentifiers `supportsMixedCaseQuotedIdentifiers as Boolean:` | No summary.
public readonly property | supportsMultipleResultSets `supportsMultipleResultSets as Boolean:` | No summary.
public readonly property | supportsMultipleTransactions `supportsMultipleTransactions as Boolean:` | No summary.
public readonly property | supportsNamedParameters `supportsNamedParameters as Boolean:` | No summary.
public readonly property | supportsNonNullableColumns `supportsNonNullableColumns as Boolean:` | No summary.
public readonly property | supportsOpenCursorsAcrossCommit `supportsOpenCursorsAcrossCommit as Boolean:` | No summary.
public readonly property | supportsOpenCursorsAcrossRollback `supportsOpenCursorsAcrossRollback as Boolean:` | No summary.
public readonly property | supportsOpenStatementsAcrossCommit `supportsOpenStatementsAcrossCommit as Boolean:` | No summary.
public readonly property | supportsOpenStatementsAcrossRollback `supportsOpenStatementsAcrossRollback as Boolean:` | No summary.
public readonly property | supportsOrderByUnrelated `supportsOrderByUnrelated as Boolean:` | No summary.
public readonly property | supportsOuterJoins `supportsOuterJoins as Boolean:` | No summary.
public readonly property | supportsPositionedDelete `supportsPositionedDelete as Boolean:` | No summary.
public readonly property | supportsPositionedUpdate `supportsPositionedUpdate as Boolean:` | No summary.
public readonly property | supportsPreparedStatements `supportsPreparedStatements as Boolean:` | No summary.
public readonly property | supportsSavepoints `supportsSavepoints as Boolean:` | No summary.
public readonly property | supportsSchemasInDataManipulation `supportsSchemasInDataManipulation as Boolean:` | No summary.
public readonly property | supportsSchemasInIndexDefinitions `supportsSchemasInIndexDefinitions as Boolean:` | No summary.
public readonly property | supportsSchemasInPrivilegeDefinitions `supportsSchemasInPrivilegeDefinitions as Boolean:` | No summary.
public readonly property | supportsSchemasInProcedureCalls `supportsSchemasInProcedureCalls as Boolean:` | No summary.
public readonly property | supportsSchemasInTableDefinitions `supportsSchemasInTableDefinitions as Boolean:` | No summary.
public readonly property | supportsSelectForUpdate `supportsSelectForUpdate as Boolean:` | No summary.
public readonly property | supportsStoredProcedures `supportsStoredProcedures as Boolean:` | No summary.
public readonly property | supportsSubqueriesInComparisons `supportsSubqueriesInComparisons as Boolean:` | No summary.
public readonly property | supportsSubqueriesInExists `supportsSubqueriesInExists as Boolean:` | No summary.
public readonly property | supportsSubqueriesInIns `supportsSubqueriesInIns as Boolean:` | No summary.
public readonly property | supportsSubqueriesInQuantifieds `supportsSubqueriesInQuantifieds as Boolean:` | No summary.
public readonly property | supportsTableCorrelationNames `supportsTableCorrelationNames as Boolean:` | No summary.
public readonly property | supportsTransactionIsolationLevel `supportsTransactionIsolationLevel as Boolean:` | No summary.
public readonly property | supportsTransactions `supportsTransactions as Boolean:` | No summary.
public readonly property | supportsUnion `supportsUnion as Boolean:` | No summary.
public readonly property | supportsUnionAll `supportsUnionAll as Boolean:` | No summary.
public readonly property | systemFunctions `systemFunctions as String:` | No summary.
public readonly property | url `url as String:` | No summary.
public readonly property | userName `userName as String:` | No summary.
public readonly property | usesLocalFilePerTable `usesLocalFilePerTable as Boolean:` | No summary.
public readonly property | usesLocalFiles `usesLocalFiles as Boolean:` | No summary.

Inherited Properties
property Inherited Properties from DatabaseMetaData: connection, driverName, driverVersion, productName, productVersion, readOnly, supportsBatchUpdates, supportsNamedParameters, supportsPreparedStatements, supportsSavepoints, supportsStoredProcedures, supportsTransactions, url, userName
Constructors

Modifier and Type | Member | Description
--- | --- | ---
public | SqlServerDatabaseMetaData `SqlServerDatabaseMetaData(connection as SqlServerConnection):` | No summary.

Methods

Modifier and Type | Member | Description
--- | --- | ---
public | catalogs `catalogs() as ResultSet throws SQLException:` | Reads SQL metadata.
public | columns `columns(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", columnPattern as String = "%") as ResultSet throws SQLException:` | Reads SQL metadata.
public | deletesAreDetected `deletesAreDetected(type as ResultSetType) as Boolean:` | No summary.
public | exportedKeys `exportedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | Reads SQL metadata.
public | functions `functions(catalog as String = "", schemaPattern as String = "", functionPattern as String = "%") as ResultSet throws SQLException:` | Reads SQL metadata.
public | generatedKeyAlwaysReturned `generatedKeyAlwaysReturned() as Boolean:` | No summary.
public | getAttributes `getAttributes(catalog as String = null, schemaPattern as String = null, typeNamePattern as String = null, attributeNamePattern as String = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | getClientInfoProperties `getClientInfoProperties() as ResultSet throws SQLException:` | Reads SQL metadata.
public | getConnection `getConnection() as Connection:` | No summary.
public | getCrossReference `getCrossReference(parentCatalog as String = null, parentSchema as String = null, parentTable as String = null, foreignCatalog as String = null, foreignSchema as String = null, foreignTable as String = null) as ResultSet throws SQLException:` | No summary.
public | getDatabaseMajorVersion `getDatabaseMajorVersion() as Int:` | No summary.
public | getDatabaseMinorVersion `getDatabaseMinorVersion() as Int:` | No summary.
public | getFunctionColumns `getFunctionColumns(functionCatalog as String = null, functionSchemaPattern as String = null, functionNamePattern as String = null, columnNamePattern as String = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | getIndexInfo `getIndexInfo(catalog as String = null, schema as String = null, table as String = null, unique as Boolean = false, approximate as Boolean = true) as ResultSet throws SQLException:` | Reads SQL metadata.
public | getMetadataApiMajorVersion `getMetadataApiMajorVersion() as Int:` | No summary.
public | getMetadataApiMinorVersion `getMetadataApiMinorVersion() as Int:` | No summary.
public | getProcedureColumns `getProcedureColumns(procedureCatalog as String = null, procedureSchemaPattern as String = null, procedureNamePattern as String = null, columnNamePattern as String = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | getPseudoColumns `getPseudoColumns(catalog as String = null, schemaPattern as String = null, tableNamePattern as String = null, columnNamePattern as String = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | getResultSetHoldability `getResultSetHoldability() as ResultSetHoldability:` | No summary.
public | getSQLStateType `getSQLStateType() as Int:` | No summary.
public | getSuperTables `getSuperTables(catalog as String = null, schemaPattern as String = null, tableNamePattern as String = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | getSuperTypes `getSuperTypes(catalog as String = null, schemaPattern as String = null, typeNamePattern as String = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | getUDTs `getUDTs(catalog as String = null, schemaPattern as String = null, typeNamePattern as String = null, types as Int[] = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | importedKeys `importedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | Reads SQL metadata.
public | indexes `indexes(catalog as String = "", schema as String = "", tableName as String = "", unique as Boolean = false) as ResultSet throws SQLException:` | Returns portable index metadata.
public | insertsAreDetected `insertsAreDetected(type as ResultSetType) as Boolean:` | No summary.
public | locatorsUpdateCopy `locatorsUpdateCopy() as Boolean:` | No summary.
public | othersDeletesAreVisible `othersDeletesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | othersInsertsAreVisible `othersInsertsAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | othersUpdatesAreVisible `othersUpdatesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | ownDeletesAreVisible `ownDeletesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | ownInsertsAreVisible `ownInsertsAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | ownUpdatesAreVisible `ownUpdatesAreVisible(type as ResultSetType) as Boolean:` | No summary.
public | primaryKeys `primaryKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException:` | Reads SQL metadata.
public | procedures `procedures(catalog as String = "", schemaPattern as String = "", procedurePattern as String = "%") as ResultSet throws SQLException:` | Reads SQL metadata.
public | schemas `schemas() as ResultSet throws SQLException:` | Reads SQL metadata.
public | supportsGetGeneratedKeys `supportsGetGeneratedKeys() as Boolean:` | No summary.
public | supportsMultipleOpenResults `supportsMultipleOpenResults() as Boolean:` | No summary.
public | supportsResultSetConcurrency `supportsResultSetConcurrency(type as ResultSetType, concurrency as ResultSetConcurrency) as Boolean:` | No summary.
public | supportsResultSetType `supportsResultSetType(type as ResultSetType) as Boolean:` | No summary.
public | supportsStatementPooling `supportsStatementPooling() as Boolean:` | No summary.
public | tableTypes `tableTypes() as ResultSet throws SQLException:` | Reads SQL metadata.
public | tables `tables(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", types as ArrayList<String> = null) as ResultSet throws SQLException:` | Reads SQL metadata.
public | typeInfo `typeInfo() as ResultSet throws SQLException:` | Reads SQL metadata.
public | updatesAreDetected `updatesAreDetected(type as ResultSetType) as Boolean:` | No summary.

Inherited Methods
method Inherited Methods from DatabaseMetaData: catalogs, columns, exportedKeys, functions, importedKeys, indexes, primaryKeys, procedures, schemas, tableTypes, tables, typeInfo