|
This section describes how to create and work with a database. As you read this section, keep the following simple concepts in mind:
The databases that you can create (called relational databases) are a collection of tables, related by primary and foreign keys. These tables hold the information in a database, and the tables and keys together define the structure of the database. A database can be stored in one or more database files, on one or more devices.
A database file also contains the system tables, which hold the schema definition as you build your database.
Creating a database
Starting a database
Connecting to a database
Setting properties for database objects
Setting database options
Specifying a consolidated database
Displaying system objects in a database
Logging SQL statements
Upgrading databases
Disconnecting from a database
Stopping a database
Erasing a database