ALTERTABLE<name>{ALTER|MODIFY}[(][COLUMN]DROPDEFAULT,[COLUMN]SETDEFAULT<seq_name>.NEXTVAL,[COLUMN]{[SET]NOTNULL|DROPNOTNULL},[COLUMN][[SETDATA]TYPE]<type>,[COLUMN]COMMENT'<string>',[COLUMN]UNSETCOMMENT[,[COLUMN]...][,...][)]ALTERTABLE<name>{ALTER|MODIFY}[COLUMN]dataGovnPolicyTagAction...
Drops the clustering key for the table. For more information about clustering keys and reclustering, see Understanding Snowflake Table Structures.Table column actions (tableColumnAction) ADD [ COLUMN ] [ IF NOT EXISTS ] col_name col_data_type [ DEFAULT default_value | AUTOINCREMENT ... ] [...
ALTER TABLE table_name ADD column_name DATE; Since the newly create column will be null, you could update it: UPDATE table_name SET column_name = cast('2022-01-01' as DATE) WHERE column_name IS NULL; you can only use a string literal when using an ALTER command to set a default...
ALTERTABLE<name>{ALTER|MODIFY}[(][COLUMN]DROPDEFAULT,[COLUMN]SETDEFAULT<seq_name>.NEXTVAL,[COLUMN]{[SET]NOTNULL|DROPNOTNULL},[COLUMN][[SETDATA]TYPE]<type>,[COLUMN]COMMENT'<string>',[COLUMN]UNSETCOMMENT[,[COLUMN]...][,...][)]ALTERTABLE<name>{ALTER|MODIFY}[COLUMN]dataGovnPolicyTagAction...