CREATE VIEW syntax in SQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a VIEW in SQL?

A VIEW is a virtual table based on the result of a SQL query. It does not store data itself but shows data from one or more tables.

beginner

Write the basic syntax to create a VIEW in SQL.

CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition;

intermediate

Can you update data through a VIEW?

Sometimes yes, if the VIEW is simple and directly maps to one table without complex joins or aggregations. Otherwise, updates are not allowed.

beginner

What happens if you try to SELECT from a VIEW?

The database runs the underlying query of the VIEW and returns the result as if it was a table.

beginner

How do you remove a VIEW from the database?

Use the command: DROP VIEW view_name;

What does the CREATE VIEW statement do?

A Inserts data into a table

B Deletes a table from the database

C Updates data in a table

D Creates a virtual table based on a SELECT query

CREATE VIEW defines a virtual table using a SELECT query.

Which keyword is used to define the columns shown in a VIEW?

A AS

B SELECT

C WHERE

D FROM

SELECT specifies the columns shown in a VIEW.

Can a VIEW contain data itself?

A Yes, but only temporary data

B Yes, it stores data permanently

C No, it only shows data from tables

D Only if created with INSERT

A VIEW does not store data; it shows data from underlying tables.

How do you delete a VIEW named 'employee_view'?

A DROP VIEW employee_view;

B DELETE VIEW employee_view;

C REMOVE VIEW employee_view;

D ERASE VIEW employee_view;

DROP VIEW is the correct command to remove a VIEW.

Which of these is a valid reason to use a VIEW?

A To simplify complex queries

B To permanently store data

C To speed up data insertion

D To delete tables

Views help simplify complex queries by encapsulating them.

Explain what a VIEW is and how to create one using SQL.

Think of a VIEW as a saved SELECT query that looks like a table.

Describe how you can use a VIEW and how to remove it when no longer needed.

Views are virtual tables you can query like real tables.