DatabaseMetaData

interfacein packageklyn.databases.sql

public interface DatabaseMetaData:

DatabaseMetaData

Database capability and catalog metadata contract.

Stable database properties are exposed directly, while catalog exploration stays on explicit methods.

import klyn.databases.sql

try connection = DriverManager.getConnection("mariadb://localhost:3306/app", "app", "secret"):
metadata = connection.metadata
print(metadata.productName)

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	columns `columns(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", columnPattern as String = "%") as ResultSet throws SQLException`	Returns metadata about visible columns.
public	exportedKeys `exportedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException`	Returns exported-key metadata for one table.
public	functions `functions(catalog as String = "", schemaPattern as String = "", functionPattern as String = "%") as ResultSet throws SQLException`	Returns function metadata.
public	importedKeys `importedKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException`	Returns imported-key metadata for one table.
public	primaryKeys `primaryKeys(catalog as String = "", schema as String = "", tableName as String = "") as ResultSet throws SQLException`	Returns primary-key metadata for one table.
public	procedures `procedures(catalog as String = "", schemaPattern as String = "", procedurePattern as String = "%") as ResultSet throws SQLException`	Returns stored-procedure metadata.
public	schemas `schemas() as ResultSet throws SQLException`	Returns visible schemas.
public	tableTypes `tableTypes() as ResultSet throws SQLException`	Returns supported table types.
public	tables `tables(catalog as String = "", schemaPattern as String = "", tablePattern as String = "%", types as ArrayList<String> = null) as ResultSet throws SQLException`	Returns metadata about visible tables.
public	typeInfo `typeInfo() as ResultSet throws SQLException`	Returns supported SQL type metadata.