SHOW COLUMN

Core command 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

SHOW COLUMN COUNTRY_ID;

Notes

Finds columns by name across the whole database: SHOW 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.

Last modified in release 4.9.8.