Contents Index Connect to the sample database from Sybase Central View the data in the database

Introducing SQL Anywhere Studio
   Tutorial: Managing Databases with Sybase Central
    Lesson 1: Start Sybase Central

Explore the database schema


The database schema is a collection of all the objects in a database. Sybase Central displays a database schema as a hierarchy of containers and their contents. This section describes how to view the schema of a database.

Expanding a database container 

Just as in the Windows Explorer, Sybase Central offers a variety of methods for viewing the objects in a database, including:

The left pane displays container objects only. The right pane displays the contents of the container object selected in the left pane. For example, when you select the Tables folder in the left pane, all of the tables within that folder appear in the right pane.

Viewing the tables in a database 

The following illustrates the steps taken to examine the contents of a table folder in a database container.

To examine the tables in the sample database

  1. Expand the Tables folder. You may have to expand asademo first.

  2. Each table in the Tables folder is itself a container. Select a table in the left pane.

    A foreign key relationship displayed in Sybase Central.
  3. Click on the various tabs in the right pane to see the contents of that tab as it relates to the selected table.

Viewing database object properties 

The properties of database objects, such as a database or a stored procedure, can be viewed using any of the following methods.

You can navigate through a database schema by clicking or double-clicking items.

Database folders 

Every Adaptive Server Anywhere database contains the following folders:

You should explore the sample database until you are comfortable locating database objects in the Sybase Central main window.


Contents Index Connect to the sample database from Sybase Central View the data in the database