Filter
Top Products
Schema definition
Schemas are managed according to schema names. Multiple schemas can be created for a single database.
Define a schema using a CREATE SCHEMA statement. A schema definition includes definitions of the base tables
and views, the elements that form the schema.
Sequence definition
A sequence can be defined to automatically generate values within the sequence. The user can use a sequence to
create primary key values.
Define a sequence using the CREATE SEQUENCE statement. The CREATE SEQUENCE statement can also be
used to add a sequence to a previously defined schema.
Table definition
A table definition defines a base table name and the columns that form the base table. Multiple base tables can be
created for a single schema. Define a base table using the CREATE TABLE statement.
The CREATE TABLE statement can also be used to add a base table to a previously defined schema.
View definition
A view definition defines a view name and the columns that form the view. Multiple views can be created for a single
schema. Define a view using the CREATE VIEW statement.
The CREATE VIEW statement can also be used to add a view to a previously defined schema.
Trigger definition
If a trigger definition is made, data can be automatically inserted into another table when an application program
updates a table.
Use the CREATE TRIGGER statement to make a trigger definition. The CREATE TRIGGER statement can also be
used to add a trigger definition to a previously defined schema.
Procedure routine definition
The database operation tasks include tasks that always process data according to a fixed pattern. These fixed-pattern
processes can be defined in a schema as a processing procedure called a procedure routine. In the procedure routine
definition, specify a procedure routine that belongs to the schema. Multiple procedure routines can be created for one
schema. Define a procedure routine using the CREATE PROCEDURE statement.
The CREATE PROCEDURE statement can also be used to add a procedure routine definition for a defined schema.
Function routine definition
A function routine definition defines a user-created application program written in C as a function. A function routine
can be defined to specify a function in an SQL statement and process it. Define a function routine using the CREATE
FUNCTION statement.
The CREATE FUNCTION statement can also be used to add a function routine to a previously defined schema.
2.6.1 Schema definition
A schema definition defines a schema name, a schema comment definition, and the following elements that form the
schema:
· Sequences
· Base tables
30