Overview > klyn.databases.sql.sqlserver > SqlServerDatabaseMetaData
Version 0.1.2 Overview Index Tree Deprecated
SqlServerDatabaseMetaData
classin packageklyn.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.
Properties inherited 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 deletesAreDetected
deletesAreDetected(type as ResultSetType) as Boolean:
 No summary.
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 getCatalogs
getCatalogs() as ResultSet throws SQLException:
 Reads SQL metadata.
public getClientInfoProperties
getClientInfoProperties() as ResultSet throws SQLException:
 Reads SQL metadata.
public getColumns
getColumns(catalog as String = null, schemaPattern as String = null, tableNamePattern as String = null, columnNamePattern as String = null) 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 getExportedKeys
getExportedKeys(catalog as String = null, schema as String = null, table as String = null) as ResultSet throws SQLException:
 Reads SQL metadata.
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 getFunctions
getFunctions(catalog as String = null, schemaPattern as String = null, functionNamePattern as String = null) as ResultSet throws SQLException:
 Reads SQL metadata.
public getImportedKeys
getImportedKeys(catalog as String = null, schema as String = null, table 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 getPrimaryKeys
getPrimaryKeys(catalog as String = null, schema as String = null, table as String = null) as ResultSet throws SQLException:
 Reads SQL metadata.
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 getProcedures
getProcedures(catalog as String = null, schemaPattern as String = null, procedureNamePattern 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 getSchemas
getSchemas(catalog as String = null, schemaPattern as String = null) as ResultSet throws SQLException:
 Reads SQL metadata.
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 getTableTypes
getTableTypes() as ResultSet throws SQLException:
 Reads SQL metadata.
public getTables
getTables(catalog as String = null, schemaPattern as String = null, tableNamePattern as String = null, types as String[] = null) as ResultSet throws SQLException:
 Reads SQL metadata.
public getTypeInfo
getTypeInfo() 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 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 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 updatesAreDetected
updatesAreDetected(type as ResultSetType) as Boolean:
 No summary.
Methods inherited from DatabaseMetaData: catalogs, columns, exportedKeys, functions, importedKeys, primaryKeys, procedures, schemas, tableTypes, tables, typeInfo