This view contains the following information on each user-defined or publicly created column:
| Column Heading | Definition |
|---|---|
| table_catalog | Database containing the column; this column is always blank, because it is limited to the current database |
| table_schema | Schema (owner) of the column; the owner can be either the current schema (user) viewing the INFORMATION_SCHEMA or the PUBLIC schema |
| table_name | Name of the table containing the column |
| column_name | Name of the column |
| ordinal_position | The column's physical location in the table |
| is_nullable | Indicates if NULL is allowed (Y/N) |
| data_type | Column data type |
| character_octet_length | Applies to char and varchar, the number of bytes in the column |
| numeric_precision | The maximum precision column for decimal and numeric data types |
| numeric_scale | The maximum scale column for decimal and numeric data types |