Adding Database Tables to the Physical View
The 'Database' panel displays available database tables and views. To add a table to the physical view, simply drag the table from the 'Database' panel into the diagram pane (on right).


To filter the list of tables, click the 'Filter Tables' button at the top of the 'Database' panel. For large databases, this provides a convenient way to quickly find the desired table or view.

Select 'Owned by user' to display only those tables that belong to the user's schema. Select 'Tables in view' or 'Tables not in view' to list tables that are, or are not, respectively, visible in the diagram pane. Use the 'Type' menu to restrict the list to either 'Tables' or 'Views'.
To list only tables that match a specified pattern, select one of 'Search' options: 'Basic' allows you to use '*' as a wildcard, while 'Regular Expression' allows Perl 5 regex syntax.
| << Defining a New Physical View | © 1996-2013 InetSoft Technology Corporation (v11.5) | Adding an Embedded SQL View >> |