Referencing Another User’s Tables

• Tables belonging to other users are not in the user’s schema.

• You should use the schema name as a prefix to those tables.
• 
  

CREATE TABLE Statement

You must have:

• storage area

CREATE TABLE [schema.]table (column datatype [DEFAULT expr][, ...]);

You specify:

• Table name
• Column name, column data type, and column size
• 
•