CREATE VIEW

SafeCreate views

CREATE VIEW <name> AS SELECT ...;

Names a query for reuse — share aggregate definitions and expose only the columns people need.

Examples

CREATE OR REPLACE VIEW active_users AS SELECT id,name FROM users WHERE deleted_at IS NULL;A view of active users

Syntax

CREATE [OR REPLACE] VIEW v AS SELECT ...; / DROP VIEW v;

Before you run it

Adds a definition only.

Related commands

SELECTRead data
GRANTGrant privileges

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store