What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL

What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
A . An error is returned and no changes are applied to the column
B. Snowflake automatically assigns a default value and let the change happen
C. Snowflake drops the row and let the change happen

View Answer

Answer: A

Explanation:

When setting a column to NOT NULL, if the column contains NULL values, an error is returned and no

changes are applied to the column.

https://docs.snowflake.com/en/sql-reference/sql/alter-table-column.html#usage-notes