For consistency and simplicity, many of the examples throughout the documentation use the SQL Anywhere sample database, demo.db. This file is installed in the SQL Anywhere samples directory: samples-dir\demo.db.

For information about the default location of samples-dir, see Samples directory.

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

User ID = DBA

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

The sample database uses the following ODBC data source: SQL Anywhere 11 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: Using the sample database.