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. You define how your data is organized when you create your databases and tables. 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
This chapter covers the creation, modification, and deletion of databases and tables, including integrity constraints.
Columns and datatypes define the type of data included in tables and are discussed in this chapter. Indexes describe how data is organized in tables. They are not considered database objects by Adaptive Server and are not listed in sysobjects. Indexes are discussed in Chapter 13, “Creating Indexes on Tables.”
