Multiple choice technology databases

How to change the definition of a view in a simple way..?

  1. drop the view and create a new one

  2. use CREATE OR REPLACE syntax

  3. use ALTER VIEW syntax

  4. use UPDATE sytax
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

CREATE OR REPLACE VIEW is the simplest way to modify a view definition - it preserves permissions and dependencies. Dropping and recreating loses permissions and requires re-granting. ALTER VIEW doesn't exist for redefining views in most databases. UPDATE syntax is for data, not DDL.

Keep practicing — related questions