klyn.databases.sql.DatabaseMetaData.columns
method
public columns(catalog as String = "",
schemaPattern as String = "",
tablePattern as String = "%",
columnPattern as String = "%") as ResultSet throws SQLException
Description

Returns metadata about visible columns.

Returned rows expose the portable core labels TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEF, NULLABLE, IS_NULLABLE, TYPE_NAME, COLUMN_SIZE, DECIMAL_DIGITS, and REMARKS. Native SQL providers also expose IS_AUTOINCREMENT and IS_GENERATEDCOLUMN as YES/NO; a generic ODBC driver may omit capability-specific labels it cannot report.

import klyn.databases.sql

columns = metadata.columns(tablePattern="users")