COLUMNS
This view stores information about each column.
Column Name | Description |
---|---|
| The name of the catalog related to the table a given column belongs to. |
| The name of the related database (schema) for a given column. |
| The name of the table a given column belongs to. |
| The name of the column. |
| The position of a given column among others in the table. |
| The default value of a given column. |
| This value is |
| Whether or not sparse compression is used on a given column. |
| The data type of a given column. |
| The maximum number of characters for a given string column. |
| The maximum length, in bytes, for a given string column. |
| The numeric precision (maximum number of digits present in a number) for a given column. |
| The numeric scale (maximum number of digits to the right the decimal point in a number) for a given column. |
| The name of the character set of a given column. |
| The collation name for the character set of a given column. |
| The data type of a given column. |
| If this column is empty, the column is not indexed or the secondary column is a non-unique index. If the value in this column is |
| Whether a given column was created with additional options such as |
| The privileges the current user has for a given column. |
| Comments (if any) from the definition of a given column. |
| The fractional-seconds precision of the column: This includes TIME and TIMESTAMP. |