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 Server - SQL Usage » Tutorial: Creating a SQL Anywhere Database

Introduction to creating a SQL Anywhere database tutorial Next Page

Lesson 1: Create a database file

In this lesson, you create a database file to hold your database. The database file contains system tables and other system objects that are common to all databases; later you will add tables.

To create a new database file
  1. Start Sybase Central.

  2. From the Tools menu, choose SQL Anywhere 10 > Create Database.

    The Create Database wizard appears.

  3. Read the information on the introductory page, and then click Next.

  4. Select Create a Database on This Computer, and then click Next.

  5. Choose a location and name for your database file.

    Type the file name c:\temp\mysample.db. If your temporary directory is somewhere other than c:\temp, specify the appropriate path.

  6. Click Finish to create the database.

    Other options are available when creating a database, but the default choices are typically sufficient.

    The Creating Database window displays the progress of the task. A Completed status indicates that the database file has been created.

  7. When the status is Completed, click Close.