Creating a New Table Definition and Instance

Figure 4-1 Process of Creating a Table Definition and Instance

Description of "Figure 4-1 Process of Creating a Table Definition and Instance"

When you select Create new table definition and instance in the Create Table screen, additional fields appear.

1. Enter values in the following fields:
   • Name. See Naming Objects.
   • Description. See Creating and Using Object Descriptions.
   • Oracle Name (up to 30 characters, uppercase, no spaces). Enter text or accept the default value. The system automatically creates the default from the text you entered in the Name field, converting it to uppercase, with underscores (_) substituted for spaces, truncated to 30 characters if necessary.
   • SAS Name (up to 32 characters, uppercase, no spaces). Enter text or accept the default value. The system automatically creates the default from the text you entered in the Name field, converting it to uppercase, with underscores (_) substituted for spaces, truncated to 32 characters if necessary.
   • Enter a SAS Label (optional, up to 256 characters). Enter text or accept the default value. The system automatically creates the default from the text you entered in the Name field.
2. In the Classification section, select the following for both the definition and the instance:
   • Subtype. Select a subtype according to your company's policies.
   • Classification Values. See Classifying Objects and Outputs for instructions.
3. Click Apply to save your work and continue defining the Table.

   The system opens the Properties screen for the new Table instance.

4. Define the details. See:
   • Setting and Modifying Table Attributes
   • Defining Table Columns
   • Defining Table Constraints and Indexes