1.0

AIRPORT VARCHAR(3),
LANGUAGE VARCHAR(16)
)
-- and a table-level foreign key constraint
CREATE TABLE METROPOLITAN
(
HOTEL_ID INT NOT NULL CONSTRAINT HOTELS_PK PRIMARY KEY,
HOTEL_NAME VARCHAR(40) NOT NULL,
CITY_ID INT CONSTRAINT METRO_FK REFERENCES CITIES
)
-- add a unique constraint to a column
CREATE TABLE METROPOLITAN
(
HOTEL_ID INT NOT NULL CONSTRAINT HOTELS_PK,
HOTEL_NAME VARCHAR(40) NOT NULL,
CITY_ID INT ,
constraint ID_Unique unique (HOTEL_ID)
)
-- create a table whose city_id column references the
-- primary key in the Cities table
-- using a column-level foreign key constraint
CREATE TABLE CONDOS
(
CONDO_ID INT NOT NULL CONSTRAINT hotels_PK PRIMARY KEY,
CONDO_NAME VARCHAR(40) NOT NULL,
CITY_ID INT CONSTRAINT city_fk REFERENCES Cities ON DELETE
RESTRICT
)
PARTITION BY Clause
The SQLFire PARTITION BY clause controls the locality and distribution of data in the given server groups.
This is important for optimizing queries, and it is essential for cross-table joins. The clause can be one of column
partitioning, range partitioning, list partitioning, or generic expression partitioning.
{
PARTITION BY { PRIMARY KEY |
PARTITION BY COLUMN Clause on page 456 ( column-name [ , column-name ]* ) }
|
PARTITION BY RANGE Clause on page 457 ( column-name )
(
VALUES BETWEEN
value
AND
value
[ , VALUES BETWEEN
value
AND
value ]*
)
|
455
SQL Language Reference