Database Object Information

Use SQL Assistant to view the following information about database objects:

Users—Displays all Oracle users.

Tables (All)—Displays all table names. Optionally displays the number of records. For tables, you can apply several predefined filters.

(USER_TABLES.NUM_ROWS). This number represents the result of a former table statistics, and might differ from the actual number of records. You can update these values, but doing so will also change the performance behavior of the industry model. To update, click Tools menu Gather Table Statistics

Tables (User Tables With Data)—Displays all user tables that contain data. User tables are non system tables. For example, in an enterprise industry model , user table names start with a prefix that indicates the module, such as WW for Wastewater, or GA for Gas.

Tables (User Tables All)—Displays all user tables.

Tables (Enterprise Industry Model System)—Displays the system tables. See also System Tables.

Tables ($)—Displays the spatial tables.

Tables (Filtered)—Displays tables using a filter expression that you enter, such as TB%.

Other database objects, such as Views, Synonyms, Sequences, Indexes, Triggers.