Dropping and altering views in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a view in a database?

A view is a virtual table that shows data from one or more tables. It does not store data itself but displays data based on a query.

beginner

How do you drop a view in MySQL?

Use the command DROP VIEW view_name; to remove a view from the database.

intermediate

Can you alter a view directly in MySQL?

No, MySQL does not support direct alteration of views. Instead, you drop the view and recreate it with the new definition.

intermediate

What is the correct way to change a view's query in MySQL?

First drop the existing view using DROP VIEW, then create a new view with the updated query using CREATE VIEW.

beginner

What happens if you try to drop a view that does not exist?

MySQL will return an error unless you use DROP VIEW IF EXISTS view_name; which avoids errors if the view is missing.

Which command removes a view named 'sales_view' in MySQL?

A DELETE VIEW sales_view;

B DROP VIEW sales_view;

C ALTER VIEW sales_view;

D REMOVE VIEW sales_view;

The correct command to remove a view is DROP VIEW followed by the view name.

How do you modify the query of an existing view in MySQL?

A Drop the view and recreate it with CREATE VIEW

B Use MODIFY VIEW command

C Update the view directly with UPDATE VIEW

D Use ALTER VIEW with new query

MySQL requires dropping the view and recreating it to change its query.

What does the command DROP VIEW IF EXISTS view_name; do?

A Creates the view if it does not exist

B Alters the view if it exists

C Drops the view only if it exists, avoiding errors

D Renames the view if it exists

This command safely drops a view only if it exists, preventing errors if it doesn't.

Which of the following is true about views?

A Views are virtual tables based on queries

B Views store data physically in the database

C Views cannot be dropped once created

D Views automatically update their structure

Views are virtual tables that show data based on queries but do not store data themselves.

If you want to change a view's structure, what is the first step?

A Use ALTER VIEW command

B Rename the view

C Update the underlying tables

D Drop the existing view

Since MySQL does not support ALTER VIEW, you must drop the view first before recreating it.

Explain how to safely remove a view in MySQL and what happens if the view does not exist.

Think about how to prevent errors when dropping something that might not be there.

Describe the process to change the query of an existing view in MySQL.

Remember MySQL's limitation on altering views.