Creating a Table

When you create a Table in a Work Area, you are actually creating an instance of a Table definition.

To create a new Table instance:

1. In a Work Area, select Table from the Add drop-down list.
2. Click Go.

   The system displays the Create Table screen.

3. Choose one of the following options:
   • Create new table definition and instance. Choose this option if no Table definition exists that can meet your needs, either as it is or with some modification.
   • Create an instance of an existing Table definition. Choose this option if an Oracle LSH Table definition already exists that meets your needs.

     If you can adapt an existing Table definition to make it fit your needs, first copy it into the current Application Area, then choose this option and select the copied definition. See Finding an Appropriate Definition and Reusing Existing Definitions for further information.

   • Create new table definition and instance from SAS data set. Choose this option if you want to create an Oracle LSH Table with the same metadata structure as an existing SAS data set.
4. Depending on your choice, follow one of the following sets of instructions:
   • Creating a New Table Definition and Instance
   • Creating an Oracle Life Sciences Data Hub Table From a SAS Data Set
   • Creating a New Instance of an Existing Table Definition
5. Modify the default attribute settings as necessary; see Setting and Modifying Table Attributes.
6. Define Columns as necessary; see Defining Table Columns.
7. Define Constraints and Indexes as necessary; see Defining Table Constraints and Indexes.

• Creating a New Table Definition and Instance
  
• Creating an Oracle Life Sciences Data Hub Table From a SAS Data Set
  You can upload SAS data set metadata into Oracle LSH to create a Table with the same structure as a data set in an integrated external system. The system creates Table Columns with the same data type and length as the variables in the data set.
• Creating a New Instance of an Existing Table Definition
  If you use an existing Table as a definition source, its Columns and other properties are already defined.