This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
ALTER VIEW .. AS
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
This statement allows for replacing the contents of an existing view.
Dialect support
This example using jOOQ:
alterView("v").as(select(one().as("a")))
Translates to the following dialect specific expressions:
-- AURORA_POSTGRES, POSTGRES, YUGABYTEDB DO $$ BEGIN DROP VIEW v; CREATE VIEW v AS SELECT 1 a; END; $$ -- DB2 BEGIN EXECUTE IMMEDIATE 'DROP VIEW v'; EXECUTE IMMEDIATE 'CREATE VIEW v AS SELECT 1 a FROM SYSIBM.DUAL'; END -- FIREBIRD EXECUTE BLOCK AS BEGIN EXECUTE STATEMENT 'DROP VIEW v'; EXECUTE STATEMENT 'CREATE VIEW v AS SELECT 1 a FROM RDB$DATABASE'; END -- H2 CREATE ALIAS block_1695310503590_7109533 AS $$ void x(Connection c) throws SQLException { try (PreparedStatement s = c.prepareStatement( "DROP VIEW v" )) { s.execute(); } try (PreparedStatement s = c.prepareStatement( "CREATE VIEW v\n" + "AS\n" + "SELECT 1 a" )) { s.execute(); } } $$; CALL block_1695310503590_7109533(); DROP ALIAS block_1695310503590_7109533; -- HANA DO BEGIN EXECUTE IMMEDIATE 'DROP VIEW v'; EXECUTE IMMEDIATE 'CREATE VIEW v AS SELECT 1 a FROM SYS.DUMMY'; END; -- MARIADB BEGIN NOT ATOMIC DROP VIEW v; CREATE VIEW v AS SELECT 1 a; END; -- MYSQL CREATE PROCEDURE block_1695310512057_3588642() MODIFIES SQL DATA BEGIN DROP VIEW v; CREATE VIEW v AS SELECT 1 a; END; CALL block_1695310512057_3588642(); DROP PROCEDURE block_1695310512057_3588642; -- ORACLE BEGIN EXECUTE IMMEDIATE 'DROP VIEW v'; EXECUTE IMMEDIATE 'CREATE VIEW v AS SELECT 1 a'; END; -- SQLDATAWAREHOUSE, VERTICA BEGIN DROP VIEW v; CREATE VIEW v AS SELECT 1 a; END; -- SQLSERVER ALTER VIEW v AS SELECT 1 a -- ACCESS, ASE, AURORA_MYSQL, BIGQUERY, COCKROACHDB, DERBY, DUCKDB, EXASOL, HSQLDB, INFORMIX, MEMSQL, REDSHIFT, SNOWFLAKE, -- SQLITE, SYBASE, TERADATA, TRINO /* UNSUPPORTED */
(These are currently generated with jOOQ 3.19, see #10141), or translate your own on our website
Feedback
Do you have any feedback about this page? We'd love to hear it!