SQL CREATE ALTER DROP VIEW

Internal

• SQL
• SQL Data Types

Overview

A view, or a virtual table, is a query that is stored in the database's data dictionary. It looks and acts like a table, but there is no data associated with the view.

CREATE

CREATE VIEW cust_view AS SELECT id, name, address FROM customer;

PostgreSQL

MySQL