COLUMNS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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. |
|
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. |
Last modified: February 6, 2023