Filter
Top Products
Example 3:
Valid table name specifications
Column definition
Define the following items for each column that forms the table:
· Column name
· Column data type
· Default value
· Column constraint
· Column comment definition
The column name and column data type must be specified in a column definition. The other items can be specified as
required.
Column name
Specify a name to be assigned to the column. For the column name, specify up to 36 alphanumeric characters
beginning with an alphabetic character. The column name must be unique within a table.
Example:
Sample column names
Column data type
Specify the data type of the column. Table: Column data types shows the types that can be specified. The data type is
determined by the type of data to be stored and the data size (length).
Example 1:
Let the data type of the PRODUCT column of the STOCK table be a 10-character fixed length
character string.
Example 2:
Same definition as example 1
34