SQL CREATE ALTER DROP VIEW

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

Overview

A view is a query that is stored in the database's data dictionary.

CREATE

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

ALTER

DROP