DatabaseMetaData
interface in package klyn.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.