Download HyperSQL User Guide

Schemas and Database Objects
of the view is updated or a new row is inserted into the view, then it should contain such values that the row would
be included in the view after the change. If WITH CASCADED CHECK OPTION is specified, then if the <query
expression> of the view references another view, then the search condition of the underlying view should also be
satisfied by the update or insert operation.
DROP VIEW
drop view statement
<drop view statement> ::= DROP VIEW [ IF EXISTS ] <table name> [ IF EXISTS ]
<drop behavior>
Destroy a view. The <drop behavior> is similar to dropping a table.
ALTER VIEW
alter view statement
<alter view statement> ::= ALTER VIEW <table name> <view specification> AS
<query expression> [ WITH [ CASCADED | LOCAL ] CHECK OPTION ]
Alter a view. The statement is otherwise identical to CREATE VIEW. The new definition replaces the old. If there
are database objects such as routines or views that reference the view, then these objects are recompiled with the new
view definition. If the new definition is not compatible, the statement fails.
Domain Creation and Manipulation
CREATE DOMAIN
domain definition
<domain definition> ::= CREATE DOMAIN <domain name> [ AS ] <predefined type>
[ <default clause> ] [ <domain constraint>... ] [ <collate clause> ]
<domain constraint> ::= [ <constraint name definition> ] <check constraint
definition> [ <constraint characteristics> ]
Define a domain. Although a DOMAIN is not strictly a type in the SQL Standard, it can be informally considered as
a type. A DOMAIN is based on a <predefined type>, which is a base type defined by the Standard. It can have
a <default clause>, similar to a column default clause. It can also have one or more CHECK constraints which
limit the values that can be assigned to a column or variable that has the DOMAIN as its type.
CREATE DOMAIN valid_string AS VARCHAR(20) DEFAULT 'NO VALUE' CHECK (value IS NOT NULL AND
CHARACTER_LENGTH(value) > 2)
ALTER DOMAIN
alter domain statement
<alter domain statement> ::= ALTER DOMAIN <domain name> <alter domain action>
<alter domain action> ::= <set domain default clause> | <drop domain default
clause> | <add domain constraint definition> | <drop domain constraint definition>
Change a domain and its definition.
61