How can a user change which columns are referenced in a view?
How can a user change which columns are referenced in a view?
To change which columns are referenced in a view, the correct approach is to recreate the view with the desired changes. This involves dropping the existing view and creating a new one with the updated column references, as modifying a view's definition directly is not supported.
Answer is C: https://docs.snowflake.com/en/sql-reference/sql/alter-view.html#alter-view
Currently the only supported operations are: Renaming a view. Converting to (or reverting from) a secure view. Adding, overwriting, removing a comment for a view. Note that you cannot use this command to change the definition for a view. To change the view definition, you must drop the view and then recreate it. https://docs.snowflake.com/en/sql-reference/sql/alter-view.html#alter-view
C: ALTER VIEW Modifies the properties for an existing view. Currently the only supported operations are: Renaming a view. Converting to (or reverting from) a secure view. Adding, overwriting, removing a comment for a view. Note that you cannot use this command to change the definition for a view. To change the view definition, you must drop the view and then recreate it.
only need to change the underlying SQL views are always replacable
C is correct
correct
To change the view definition, you must drop the view and then recreate it.
Note that you cannot use this command to change the definition for a view. To change the view definition, you must drop the view and then recreate it.
No I think we can create and replave the view, with modified changes no need to drop the view.