Creating a Table

To create a table:

  1. Open the project for which you want to build SQL tables.

  2. Select Build, and then Project.

  3. From the Build menu, select the appropriate scope of your build.

    See Selecting the Build Scope.

    The Build dialog box appears.

  4. Select the Create Tables in the Build Options group box.

    PeopleSoft Application Designer automatically activates the Create Indexes option. If you are rebuild or recreate tables, then the indexes that the system uses to extract information from those tables must also be updated. Definitions to be built appear in the Build Scope list box, which does not allow you to edit, remove, or add definitions.

  5. Select one of the Build Execute options.

    The default option builds an SQL script file containing the commands to run the selected build options.

  6. Click the Settings button in the Build dialog box to set user-defined defaults.

    The Create tab in the Build Settings dialog box appears.

  7. Select the appropriate settings on the Create tab.

    See Specifying Create Options.

    Recreating a table removes all data contained in the table as well as views or grants referencing that table.

  8. Select the Logging tab.

  9. Set the Logging Levels and associated options.

    See Specifying Logging Options.

  10. Select the Scripts tab.

  11. Specify the script file options.

    If you selected Execute SQL Now as your build option in the Build dialog box, you can skip the Scripts tab because you will run the SQL online. Settings on the Scripts tab are relevant only if you are building a SQL script to run later.

    See Specifying Script Options.

  12. Click OK to close the Build Settings dialog box.

  13. In the Build dialog box, click the Build button to run your build option.

    The length of a Build process depends on the number of definitions that require building. Watch the Build Progress dialog box to monitor the Build process. When the process completes, check any errors listed in the log file.