1.0

• ASYNCEVENTLISTENER Keyword on page 462
• EVICTION BY Clause on page 462
• EXPIRE Clause on page 463
• PERSISTENT Keyword on page 464
• ASYNCHRONOUS and SYNCHRONOUS Attributes on page 464
Syntax
Tables contain columns and constraints, rules to which data must conform. Table-level constraints specify a
column or columns. Columns have a data type and can specify column constraints (column-level constraints).
The syntax of CREATE TABLE is extended to give properties to the tables that are specific to SQLFire.
The CREATE TABLE statement has two variants depending on whether you are specifying the column definitions
and constraints (CREATE TABLE), or whether you are modeling the columns after the results of a query
expression (CREATE TABLE...AS...).
CREATE TABLE table-name {
( {
Column Definition on page 451
|
Table Constraint on page 453
}
[, { column-definition | table-constraint } ] * )
|
[( column-name [, column-name ] * ) ]
AS query-expression
WITH NO DATA
}
[
PARTITION BY Clause on page 455
| REPLICATE ]
[
SERVER GROUPS Clause on page 461
( server_group_name [, server_group_name ]* ) ]
[
GATEWAYSENDER Keyword on page 461
( sender-name [,sender-name ] * ) ]
[
ASYNCEVENTLISTENER Keyword on page 462
(async-listener-id [,async-listener-id]...) ]
[ EVICTION BY {
EVICTION BY Clause on page 462
} EVICTACTION { OVERFLOW | DESTROY } ]
[
EXPIRE Clause on page 463
{ TABLE | ENTRY } WITH { IDLETIME value | TIMETOLIVE value} ACTION { DESTROY
| INVALIDATE } ]*
[
PERSISTENT Keyword on page 464
] [ 'disk-store-name' ] [ ASYNCHRONOUS | SYNCHRONOUS ]
Example of CREATE TABLE
CREATE TABLE HOTELAVAILABILITY
(HOTEL_ID INT NOT NULL,
BOOKING_DATE DATE NOT NULL,
vFabric SQLFire User's Guide450
vFabric SQLFire Reference