SQL Views

Database views — CREATE VIEW, DROP VIEW, ALTER VIEW, materialized views. This category documents 24 SQL views entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: CREATE VIEW, DROP VIEW, ALTER VIEW, MATERIALIZED VIEW, CREATE OR REPLACE VIEW, WITH CHECK OPTION, INDEXED VIEW (WITH SCHEMABINDING), View WITH ENCRYPTION, View WITH READ ONLY, View WITH SCHEMABINDING, View Dependencies, Updatable Views (Rules), SHOW CREATE VIEW, View with ALGORITHM (MySQL), View with CHECK OPTION (LOCAL/CASCADED), View Usage Best Practices, View with NOEXPAND, PERSISTED View / Snapshots, LATERAL VIEW (Hive/Spark SQL), View with IF NOT EXISTS, View with GRANT Permissions, Local vs Global Temporary Views, PostgreSQL WITH CHECK OPTION (Views), SQL GRANT SELECT ON VIEW. Not sure where to start? CREATE VIEW and DROP VIEW are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.