Defining a Database
This chapter describes the SQL statements for creating and managing the database structure. Examples are based on the database listed in Example Database.
In addition, BSQL provides specific commands for listing and describing database objects, see Mimer BSQL.
SQL includes statements for creating and modifying the database structure:
- create idents, schemas, databanks, shadows, domains, sequences, tables, triggers, functions, procedures, modules, views, indexes and synonyms
- saving documentary comments on objects
- altering the definition of idents, databanks, shadows and tables
- dropping objects from the database.
All information describing the database structure is stored in the data dictionary.
Before the database is defined, it is extremely important to design the database model. Well-functioning and efficient databases cannot be created without a model as the foundation.
Without careful design, much of the flexibility and efficiency inherent in a relational database structure may be lost.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40