FIND COLUMN

Core command FI COL FICOL SHOW COLUMN SH COL SHCOL

Show tables having a column name that contain the input text

Arguments

<columnName> (mandatory) the name of the column. Part of the name can be used.

Examples

FIND COLUMN COUNTRY_ID;

Notes

Finds columns by name across the whole database: FIND COLUMN <columnName>.

columnName is mandatory and is matched as a substring (the search text is used exactly as typed, not case-normalized here - matching follows the database driver's own pattern-matching rules). The search is not restricted to a schema or table: every column in the database whose name contains the given text is listed, with its table.

Fails with an error if no search text is given.

SHOW COLUMN/SH COL/SHCOL still work: FIND COLUMN is the same command under a new, recommended name - the first of a planned FIND family (locating an entity by a fact belonging to a different category, e.g. a table by one of its column names) that reads better as FIND than SHOW. No behavior change, and the older keywords are not going away - same precedent as PULL superseding EXPORT/DUMP without removing them. New scripts should prefer FIND COLUMN.

Last modified in release 5.0.8.