Filter
Top Products
· View tables
· Triggers
· Procedure routines
· Function routines
Define the schema name using the schema definition statement (CREATE SCHEMA statement).
A sample schema definition for the inventory management database follows. The schema named STOCKS and the
tables that belong to it, such as the STOCK table, are defined for STOCKMN_DB.
Example:
Define a schema for STOCKMN_DB.
Schema name
For the schema name, specify up to 36 alphanumeric characters beginning with an alphabetic character. The schema
name must be unique within the database.
When sequences, base tables, and view tables are specified in SQL statements, the schema name is used to qualify
the sequence and table names. The schema name is also used to qualify the table names if an index is specified in an
31