CREATE TABLE dept1 AS department WITH NO DATA;
CREATE TABLE dept1, NO FALLBACK AS department WITH NO DATA
UNIQUE INDEX (department_name);
CREATE TABLE SampDb.PhoneList
,FALLBACK
,NO BEFORE JOURNAL
,NO AFTER JOURNAL
(
Number CHAR(10) TITLE 'Number' NOT NULL
,Name CHAR(25) TITLE 'Name' NOT NULL
,LType CHAR(4) TITLE 'Line Type'
,Calls INTEGER TITLE 'Calls Made' FORMAT 'zzz9'
,Take CHAR(1) TITLE 'Important'
)
UNIQUE PRIMARY INDEX( Number );
CREATE TABLE PhoneUS
AS (
SELECT * FROM PhoneList WHERE country = 'US'
) WITH DATA;