INFORMATION_SCHEMA.COLUMNS

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