Download Sample DB

If you select a single DBMS, it will be downloaded directly. If, however, you select more than one DBMS, you will download a ZIP file with the selected files.

This is a generic script using standard ANSI SQL. It should work on any normal DBMS. Note, however, that it may run slowly on SQLite.

The generic script does not include CREATE or TRUNCATE statements, as they are too vendor-specific.

The CREATE TABLE code for PostreSQL includes the the older SERIAL syntax for auto-incremented primary keys.

The CREATE TABLE code for PostreSQL includes the the newer GENERATED BY DEFAULT AS IDENTITY syntax for auto-incremented primary keys.

The script is in SQLite 3 format. It includes an empty SQLite File.

This generates a database file called sampledb.sqlite The database is in SQLite 3 format.

This is the ANSI Mode version.

The most obvious differences are that ANSI mode uses "double quotes" for Column Names, and the || operator is used for concatenation.

The is the Traditional Mode version.

The most obvious differences are that Traditional mode uses `back ticks` for Column Names, and that the || operator doesn’t concatenate.

Before 2016, you can’t use DROP TABLE IF EXISTS, so the CREATE script uses IF OBJECT_ID('…','U').

See notes on installing Microsoft SQL Server and setting up SSMS

The CREATE script uses DROP TABLE IF EXISTS.

See notes on installing Microsoft SQL Server and setting up SSMS

Prior to version 12, Oracle did not support IDENTITY columns for auto-incremented keys, so this script includes the workaround using triggers. The IDENTITY statement is commented out, so, if you want to use it, uncomment it and comment out the plain version in each CREATE TABLE statement.

The older version script will still work well enough on newer versions of Oracle.

From version 12, Oracle supports IDENTITY columns for auto-incremented keys.

This script does not include SET DEFINE OFF;, so it may not work properly with the SQLPlus client.

From version 12, Oracle supports IDENTITY columns for auto-incremented keys, as well as batched INSERT.

This script includes SET DEFINE OFF;, which is good for SQLPlus, but it may not work properly with other clients.

From version 23c, Oracle supports IDENTITY columns for auto-incremented keys, as well as batched INSERT statements.

This script does not include SET DEFINE OFF;, so it may not work properly with the SQLPlus client.

From version 23c, Oracle supports IDENTITY columns for auto-incremented keys, as well as batched INSERT statements.

This script includes SET DEFINE OFF;, which is good for SQLPlus, but it may not work properly with other clients.

Experimental Support for Db2

Tested on:

• Db2 v12.1.1.0 LUW on Docker
• DB2 v11.5.9.0 LUW on IBM Cloud