ASA SQL User's Guide
  Working with Database Objects

Introduction

With the Adaptive Server Anywhere tools, you can create a database file to hold your data. Once this file is created, you can begin managing the database. For example, you can add database objects, such as tables or users, and you can set overall database properties.

This chapter describes how to create a database and the objects within it. It includes procedures for Sybase Central, Interactive SQL, and command-line utilities. If you want more conceptual information before you begin, see the following chapters:

• Designing Your Database

• Ensuring Data Integrity

• About Sybase Central

• Using Interactive SQL

The SQL statements for carrying out the tasks in this chapter are called the data definition language (DDL). The definitions of the database objects form the database schema: you can think of the schema as an empty database.

Procedures and triggers are also database objects, but they are discussed in Using Procedures, Triggers, and Batches.

Chapter contents 

This chapter contains the following material:

• An introduction to working with database objects (this section)

• A description of how to create and work with the database itself

• A description of how to create and alter tables, views, and indexes