Filtering schemas

To specify which schemas to include in the Available tables list:

  1. Click Filter schemas. The Filter Schemas window opens.

  2. To add a schema to the Available tables list, click on a schema name in the Available schemas list, then click >. The schema name moves to the Selected schemas list. To select all of the schemas, click >>.

    When you add a schema, the Available tables list on the Tables page displays all of the tables in the database that are in the specified schema.

    To remove a schema from the Selected schemas list, click on its name in the Selected schemas list, then click <. To remove all of the schemas from the Selected schemas list, click <<.

    When you remove a schema, it is no longer displayed in the Available tables list on the Tables page.

  3. Depending on the application that you were using when you entered SQL Assist, you might be able to specify additional schemas:

    1. Type the name of the schema that you want to add in the Enter additional schema names field.

    2. Click Add. The schema name is added to the Selected schemas list.

  4. Click OK.

../rule.gif

Back to Specifying the tables for an SQL statement