A clustering key was defined on a table, but it is no longer needed.
How can the key be removed?
A clustering key was defined on a table, but it is no longer needed.
How can the key be removed?
The correct command to remove a clustering key from a table is 'ALTER TABLE [TABLE NAME] DROP CLUSTERING KEY'. This is because in SQL terminology, the keyword 'DROP' is standard for removing an object or constraint from a table, including clustering keys.
ALTER TABLE <name> DROP CLUSTERING KEY
https://docs.snowflake.com/en/sql-reference/sql/alter-table.html C
I Think the correct answer is C
Alter table <sssss> drop clustering key
C is the correct one
Dropping the Clustering Keys for a Table At any time, you can drop the clustering key for a table using ALTER TABLE: ALTER TABLE <name> DROP CLUSTERING KEY
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
C https://docs.snowflake.com/en/user-guide/tables-clustering-keys#defining-clustered-tables
C https://docs.snowflake.com/en/user-guide/tables-clustering-keys
C is correct
C is correct answer