5.4.5 Loading Quick SQL Sample Models
Learn about Quick SQL shorthand syntax by loading Quick SQL sample models.
- About Quick SQL Sample Models
Learn about available Quick SQL sample models. - Loading a Quick SQL Sample Model
Access Quick SQL sample models by selecting the Load action from the Quick SQL Actions menu, or by clicking Help and selecting Samples.
Parent topic: Using Quick SQL
5.4.5.1 About Quick SQL Sample Models
Learn about available Quick SQL sample models.
Quick SQL includes the following Quick SQL sample models:
-
Departments and Employees - Creates a
DEPARTMENTS
andEMPLOYEES
tables with an additionalEMP_V
join view. Random data is also generated using/INSERT
syntax. The/NN
adds aNOT NULL SQL
column constraint. Indented lists are used to define tables, columns and child tables. Primary and foreign key columns are automatically added. You do not need to supply any primary or foreign key columns. -
Employee Skills - Creates a
DEPARTMENTS
,EMPLOYEES
, andSKILLS
table using indentation to identify parent and child tables. Shorthand syntaxVC255
specifies the SQL datatype. The/INSERT
syntax is used to generate ten rows of random data and provides example values (/VALUES
). Defines legal values with a check constraint (/CHECK
). Illustrates adding a column comment in square brackets. -
Product Sales - Creates a star schema with
PRODUCTS
,CUSTOMERS
,CHANNELS
,PROMOTIONS
, andSALES
tables. TheSALES
table contains foreign key references to the other tables. ASQL VIEW
is also created which joins all five tables. Random sample data is also generated. Numeric column are identified withNUM
syntax. -
Project Management - Defines project management schema with a
PROJECTS
parent table and four child tables:MILESTONES
,LINKS
,ATTACHMENTS
, andACTION_ITEMS
. Adds the viewPROJECT_MS
joiningPROJECTS
andMILESTONES
andPROJECT_AI
combiningPROJECTS
andACTION_ITEMS
. Specifies legal values (/CHECK
), example values (/VALUES
), and generates sample rows (/INSERT
). Adds audit columns in SQL syntax directives after#-sign (auditcols: true)
. -
ToDos - Creates
ASSIGNEES
andTODOS
tables. Defines NOT NULL constraints (/NN
). Specifies legal values (/CHECK
). Generates sample data (/INSER
T). Adds audit columns (#auditcols: true
). This sample is designed as a starting point to enable the creation of a customized ToDo system within minutes.
Parent topic: Loading Quick SQL Sample Models
5.4.5.2 Loading a Quick SQL Sample Model
Access Quick SQL sample models by selecting the Load action from the Quick SQL Actions menu, or by clicking Help and selecting Samples.
To load the Quick SQL samples:
Parent topic: Loading Quick SQL Sample Models