Resources

CREATE VIEW Statement

duckdb.org

The CREATE VIEW statement defines a new view in the catalog. Examples Create a simple view: CREATE VIEW view1 AS SELECT * FROM tbl; Create a view or replace it if a view with that name already exists: CREATE OR REPLACE VIEW view1 AS SELECT 42; Create a view and replace the column names: CREATE VIEW view1 (a) AS SELECT 42; New The SECURE VIEW feature will be introduced in DuckDB 2.0. Create a secure view (hides inter…

Visit Site