Snowflake · Schema
TableColumn
A column in the table
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| name | string | Column name |
| datatype | string | The data type for the column |
| nullable | boolean | Specifies that the column does allow NULL values or not. |
| collate | string | Specifies the collation to use for column operations such as string comparison |
| default | string | Specifies whether a default value is automatically inserted in the column if a value is not explicitly specified via an INSERT or CREATE TABLE AS SELECT statement |
| autoincrement | boolean | |
| autoincrement_start | integer | The default value for the column starts with the specified number |
| autoincrement_increment | integer | Each successive value for the column automatically increments by the specified amount |
| constraints | array | |
| comment | string | Specifies a comment for the column |