DatabaseMetaData - Klyn API

DatabaseMetaData

interfacein packageklyn.databases.sql

public interface DatabaseMetaData:

DatabaseMetaData

Database capability and catalog metadata contract inspired by `java.sql.DatabaseMetaData`. Stable database properties are exposed directly, while catalog exploration stays on explicit methods.

import klyn.databases.sql

metadata = connection.metadata
print(metadata.productName)

Fields

Modifier and Type	Member	Description
public	columns(catalog `columns(catalog as String = "",`	Returns metadata about visible columns.
public	exportedKeys(catalog `exportedKeys(catalog as String = "",`	Returns exported-key metadata for one table.
public	functions(catalog `functions(catalog as String = "",`	Returns function metadata.
public	importedKeys(catalog `importedKeys(catalog as String = "",`	Returns imported-key metadata for one table.
public	primaryKeys(catalog `primaryKeys(catalog as String = "",`	Returns primary-key metadata for one table.
public	procedures(catalog `procedures(catalog as String = "",`	Returns stored-procedure metadata.
public	tables(catalog `tables(catalog as String = "",`	Returns metadata about visible tables.

Properties

Modifier and Type	Member	Description
public readonly property	connection `connection as Connection`	Owning connection.
public readonly property	driverName `driverName as String`	Driver name.
public readonly property	driverVersion `driverVersion as String`	Driver version.
public readonly property	productName `productName as String`	Database product name.
public readonly property	productVersion `productVersion as String`	Database product version.
public readonly property	readOnly `readOnly as Boolean`	True when the connection is read-only.
public readonly property	supportsBatchUpdates `supportsBatchUpdates as Boolean`	True when batch updates are supported.
public readonly property	supportsNamedParameters `supportsNamedParameters as Boolean`	True when named parameters are supported.
public readonly property	supportsPreparedStatements `supportsPreparedStatements as Boolean`	True when prepared statements are supported.
public readonly property	supportsSavepoints `supportsSavepoints as Boolean`	True when savepoints are supported.
public readonly property	supportsStoredProcedures `supportsStoredProcedures as Boolean`	True when stored procedures are supported.
public readonly property	supportsTransactions `supportsTransactions as Boolean`	True when transactions are supported.
public readonly property	url `url as String`	Effective connection URL.
public readonly property	userName `userName as String`	Effective user name.

Methods

Modifier and Type	Member	Description
public	catalogs `catalogs() as ResultSet throws SQLException`	Returns visible catalogs.
public	schemas `schemas() as ResultSet throws SQLException`	Returns visible schemas.
public	tableTypes `tableTypes() as ResultSet throws SQLException`	Returns supported table types.
public	typeInfo `typeInfo() as ResultSet throws SQLException`	Returns supported SQL type metadata.