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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Introduction » Sample databases


SQL Anywhere sample database

For consistency and simplicity, many of the examples throughout the documentation use the SQL Anywhere sample database, %SQLANYSAMP16%\demo.db. By default this file is installed in the SQL Anywhere samples directory (for example, C:\Users\Public\Documents\SQL Anywhere 16\Samples on Windows 7).

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 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 (Sybase Central).

The sample database uses the following ODBC data source: SQL Anywhere 16 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.
 Roles in the sample database
 See also

Recreate the sample database (demo.db)