SqlServerDatabaseMetaData

classin packageklyn.databases.sql.sqlserver

public class SqlServerDatabaseMetaData implements DatabaseMetaData, TargetedDatabaseMetaData

All Implemented Interfaces: DatabaseMetaData, TargetedDatabaseMetaData

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.

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	targetedColumns `targetedColumns( catalog as String, schema as String, tableNames as IList<String> ) as ResultSet throws SQLException`	No summary.
public	targetedImportedKeys `targetedImportedKeys( catalog as String, schema as String, tableNames as IList<String> ) as ResultSet throws SQLException`	No summary.
public	targetedIndexes `targetedIndexes( catalog as String, schema as String, tableNames as IList<String>, unique as Boolean ) as ResultSet throws SQLException`	No summary.
public	targetedPrimaryKeys `targetedPrimaryKeys( catalog as String, schema as String, tableNames as IList<String> ) as ResultSet throws SQLException`	No summary.
public	targetedTables `targetedTables( catalog as String, schema as String, tableNames as IList<String>, types as IList<String> ) as ResultSet throws SQLException`	No summary.
public	typeInfo `typeInfo() as ResultSet throws SQLException`	Reads SQL metadata.
public	updatesAreDetected `updatesAreDetected(type as ResultSetType) as Boolean`	No summary.

Inherited Methods

methodInherited Methods from DatabaseMetaData: columns, exportedKeys, functions, importedKeys, primaryKeys, procedures, tables