Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Introduction » SQL Anywhere Sample Database

SQL Anywhere Sample Database Next Page

About the sample database


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.)

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 represents a small company that sells athletic clothing. It contains internal information about the company (employees, departments, and finances), as well as 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.

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