Select tables for a view

  1. On the New View dialog, click Select Tables. The Browse Tables dialog opens.
  2. On the Browse Tables dialog, select the tables or view that you want to create a new view from and click Add, or drag the object to the work area of the New View dialog. The selected table or view appears in the work area of the dialog.
  3. Click OK to return to the New View dialog.

Note: There can only be one occurrence of a table in the work area. This means you cannot define a join of a table to itself. Tables can be dragged and dropped by their title bars within the work area. To remove a table from the work area, click on the table title bar and press the Delete key. Pressing the Delete key also deletes the corresponding entries in the selection grid and any join relationships for the table. To use existing tables with embedded double quotes in the name, you must use Edit SQL and place another double quote next to the one that is embedded (for example, ""my"" table instead of "my" table). The statement must then be run on system using the Submit button on the Edit SQL dialog.

Once you have selected the table or view, you can then select the columns to make up your new view.