Fujitsu J2X0-2273-01EN Server User Manual


 
statement that defines the STOCK table.
[Figure: CREATE TABLE statement that defines the STOCK table]
Table name
Specify a name to be assigned to the base table using up to 36 alphanumeric characters beginning with an alphabetic
character.
The table name must be unique within the schema. The same table name can be defined in other schemas.
When a table definition is specified as a schema definition element and the table name is modified by a schema name,
the table name must be same as the schema name specified in the schema definition. When the table name is not
modified by the schema name, the table name is considered to be modified by the schema name specified in the
schema definition.
The table name is used to specify the table to be manipulated by a data manipulation SQL statement.
Example 1:
Sample table names
Example 2:
Invalid table name specification
33