Lesson 1: Creating a database file

Create a database file to hold your data. The database file contains system tables and other system objects that are common to all databases.

Prerequisites

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Creating a SQL Anywhere database.

Start Sybase Central. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.
Start the Create Database Wizard. Click Tools » SQL Anywhere 16 » Create Database.
1. On the Welcome page, click Next.
2. Click Create a database on this computer, and then click Next.
3. In the Save the main database file to the following file field, type c:\temp\mysample.db.
  
  If your temporary directory is somewhere other than c:\temp, specify the appropriate path.
4. On the Specify DBA user and Password page, specify the DBA user ID and password. By default, the user ID is DBA and the password is sql. However, it is recommended that you change these settings to ensure that your database is secure.
5. Click Finish and then click Close.
  
  You are automatically connected to the database as the DBA user.

Results

You have created and connected to a database.

Next

Proceed to Lesson 2: Adding tables to the database.