5.4.6 Loading Quick SQL Samples
Load and view Quick SQL samples to learn about about SQL shorthand syntax.
- About Quick SQL Samples
Quick SQL includes the following samples. - Loading a Quick SQL Sample
Access Quick SQL samples from either the Load or Help windows.
Parent topic: Using Quick SQL
5.4.6.1 About Quick SQL Samples
Quick SQL includes the following samples.
You can load these samples by clicking either the Help or Load buttons above the Quick SQL Shorthand pane. Available Quick SQL samples include:
-
Departments and Employees - Shorthand SQL syntax creates a
DEPARTMENTS
andEMPLOYEES
table with a SQL joinVIEW
. 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
is used to specify a SQL datatype. The/INSERT
syntax is used to generate random data. -
Product Sales - Short hand syntax that 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. -
ToDos - Creates
ASSIGNEES
andTODOS
tables. This sample is designed as a starting point to enable the creation of a customized ToDo system within minutes.
Parent topic: Loading Quick SQL Samples
5.4.6.2 Loading a Quick SQL Sample
Access Quick SQL samples from either the Load or Help windows.
To access the Quick SQL samples:
Parent topic: Loading Quick SQL Samples