A database stores information (data) in a set of database objects, such as tables, that relate to each other. A table is a collection of rows that have associated columns containing individual data items. When you create databases and tables, you are deciding the organization of your data. This process is called data definition.

Adaptive Server database objects include:

• Tables

• Rules

• Defaults

• Stored procedures

• Triggers

• Views

• Referential integrity constraints

• Check integrity constraints

• Functions

• Computed columns

• Partition conditions