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.
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store