Skip to content

Home

Jump to bottom
Cristi Scutaru edited this page Oct 26, 2019 · 4 revisions

Employees Test Database

EmployeesQX is a very simple database to be used for testing in relational database systems. It is inspired from similar test databases included in Oracle, MySQL or other database systems over the years. Download SQL scripts and some ready-to-use binary database files.

Changelog

  • Added referential constraints for most databases (as ON DELETE/UPDATE foreign key clauses).
  • Added materialized views for Oracle, PostgreSQL, SQL Anywhere, DB2 (as MQT), SQL Server (as indexed views).
  • Added table and column comments/descriptions/remarks.

Supported Databases

  • Oracle
  • IBM Db2
  • Microsoft SQL Server
  • Microsoft Azure Database
  • Microsoft SQL Server CE
  • Microsoft Access
  • PostgreSQL
  • Amazon Redshift
  • MySQL
  • Amazon Aurora
  • MariaDB
  • SAP/Sybase ASE
  • SAP/Sybase SQL Anywhere
  • SQLite
  • Firebird

Please participate to this project with similar SQL scripts for other database systems.

Clone this wiki locally