SQL Anywhere sample database

For consistency and simplicity, many of the examples throughout the documentation use the SQL Anywhere sample database, %SQLANYSAMP12%\demo.db. By default this file is installed in the SQL Anywhere samples directory: C:\Documents and Settings\All Users\Documents\SQL Anywhere 12\Samples.

The sample database uses the following default user ID and password:

  • User ID = DBA

  • Password = sql (passwords in SQL Anywhere are case sensitive)

Caution

The sample database always has the same user ID and password; it is recommended that you change the DBA user ID and password to restrict access to the database. See Changing a password.

The sample database uses the following ODBC data source: SQL Anywhere 12 Demo.

The sample database represents a small company that sells athletic clothing. It contains internal information about the company (employees, departments, and finances), product information, and sales information (sales orders, customers, and contacts). All data in the database is fictional.

The following figure displays the tables in the sample database and how they are related to each other. The boxes represent tables, and the arrows represent foreign key relationships.

For instructions on how to connect to demo.db, see Tutorial: Connecting to the sample database.

The SQL Anywhere sample database, including tables, column names, primary keys, and foreign key relationships.

Recreate the sample database (demo.db)