Chapter 9 SQL Statements
475
If you use CHECK ON COMMIT with out specifying any actions,
then RESTRICT is implied as an action for UPDATE and
DELETE.
$ For information on the WITH HASH clause that can be used with
this constraint, see "CREATE INDEX statement" on page 448.
♦
SQL/92 Entry level feature.
The following are vendor extensions:
♦ The { IN | ON } dbspace-name clause.
♦ The ON COMMIT clause
♦ Some of the default values.
♦
Sybase Supported by Adaptive Server Enterprise, with some
differences.
♦
Temporary tables You can create a temporary table by preceding
the table name in a CREATE TABLE statement with a pound sign
(#). In Adaptive Server Anywhere, these are declared temporary
tables, which are available only in the current connection. For
information, see "DECLARE LOCAL TEMPORARY TABLE
statement" on page 495.
♦
Physical placement Physical placement of a table is carried out
differently in Adaptive Server Anywhere and in Adaptive Server
Enterprise. The ON segment-name clause supported by Adaptive
Server Enterprise is supported in Adaptive Server Anywhere, but
segment-name refers to a dbspace name.
♦
Constraints Adaptive Server Anywhere does not support named
constraints or named defaults, but does support domains, which
allow constraint and default definitions to be encapsulated in the
data type definition. It also supports explicit defaults and CHECK
conditions in the CREATE TABLE statement.
♦
NULL default By default, columns in Adaptive Server Enterprise
default to NOT NULL, whereas in Adaptive Server Anywhere the
default setting is NULL. This setting can be controlled using the
ALLOW_NULLS_BY_DEFAULT database option. You should
explicitly specify NULL or NOT NULL to make your data
definition statements transferable between Adaptive Server
Anywhere and Adaptive Server Enterprise.
$ For more information, see
"ALLOW_NULLS_BY_DEFAULT option" on page 169.
♦ Create a table for a library database to hold book information.
Standards and
compatibility
Examples
To Next Page
Loading...