Filter
Top Products
- Column name
- Column comment definition
· Query specification
· Table (view) comment definition
A sample view definition for the inventory management database follows. This view definition defines a view consisting
of the rows of the ITMNO and STOCKQTY columns of the STOCK table for which STOCKQTY is at least 50.
Example:
CREATE VIEW statement that defines the MASS_STOCK view
Table name (view name)
Specify a name to be assigned to the view. For the table name, specify up to 36 alphanumeric characters beginning
with an alphabetic character.
A view name is unique in a schema.
Example:
Sample view name specification
View column list
Specify column names for the columns that form the view.
Column name
Specify names for each of the columns that form the view. For the column name, specify up to 36 alphanumeric
characters beginning with an alphabetic character.
A column name is unique in a view.
Example:
Define a view having column names NO and QTY.
Column comment definition
A comment consisting of a character string can be specified for each column in the view. A character string of up to
256 bytes can be specified. If no comment is necessary, omit the specification. An example follows.
Example:
42