Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 119 / 536

99
C H A P T E R 3
Working with Database Objects
About this chapter This chapter describes the mechanics of creating, altering, and deleting
database objects such as tables, views, and indexes. The SQL statements
for carrying out these tasks 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 are also database objects, but are discussed in Chapter 6,
“Using Procedures and Batches”
Note Remember that Adaptive Server IQ consists of both a Catalog Store
and an IQ Store. This chapter explains how you create both stores, and the
objects in your IQ Store. Tables created in the Catalog Store have the
characteristics of Adaptive Server Anywhere tables. If you want to create
tables in the Catalog Store, you need to refer to the Adaptive Server
Anywhere documentation.
Building Your Adaptive Server IQ Databases
This section introduces you to the steps involved in creating a database,
and the tools you use. It also explains decisions you need to make about
where to store the data, how much space it will require, and who will be
able to define or modify database objects.
Designing your database
It's important to design your database before you actually create it. The
right database design can make a major difference in the usefulness of
your data, and the speed with which you can retrieve it.