OR REPLACE

// Create a new view
create.createOrReplaceView("early_authors", "author_id", "first_name", "last_name")
      .as(select(AUTHOR.ID, AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)
          .from(AUTHOR)

          // Any inserted or updated authors must continue to satisfy this condition
          .where(AUTHOR.ID.lt(200)))
      .execute();

createOrReplaceView("a", "id").as(select(AUTHOR.ID).from(AUTHOR))

-- ASE, AURORA_POSTGRES, BIGQUERY, COCKROACHDB, DB2, DUCKDB, EXASOL, H2, HANA, MARIADB, MYSQL, ORACLE, POSTGRES, VERTICA, 
-- YUGABYTEDB
CREATE OR REPLACE VIEW a(id)
AS
SELECT AUTHOR.ID
FROM AUTHOR

-- FIREBIRD, SQLSERVER
CREATE OR ALTER VIEW a(id)
AS
SELECT AUTHOR.ID
FROM AUTHOR

-- TERADATA
REPLACE VIEW a(id)
AS
SELECT AUTHOR.ID
FROM AUTHOR

-- TRINO
CREATE OR REPLACE VIEW a
AS
SELECT t.id
FROM (
  SELECT AUTHOR.ID
  FROM AUTHOR
) t (id)

-- ACCESS, AURORA_MYSQL, DERBY, HSQLDB, INFORMIX, MEMSQL, REDSHIFT, SNOWFLAKE, SQLDATAWAREHOUSE, SQLITE, SYBASE
/* UNSUPPORTED */