Scalable Database Server, HiRDB Version 8 Description

[Contents][Glossary][Index][Back][Next]

3.2 Schemas

Tables, indexes, abstract data types (user-defined types), index types, stored procedures, stored functions, triggers, and access privileges are subsumed under a concept known as a schema. Before you can define any of these resources, you must define a schema. To define a schema, you use the definition SQL CREATE SCHEMA statement. One schema can be defined for each user. Figure 3-3 shows the concept of schemas.

Figure 3-3 Concept of schemas

[Figure]