EM: Databases/SQL: Databases > Views

Description

The Databases Views provides access to database views, listing defined views with their names and descriptions, and enabling creation, modification, and inspection of view definitions, including query statements that determine how underlying data is presented when the view is accessed.

Note: selecting a database from Databases name list, opens its configuration interface, and enabling access to Views.

Location

EM Navigator → Databases/SQL → Databases → Views

Toolbar

Button	Function
	Creates a news view.
	Edits selected view.
	Removes/deletes selected view.
	Refreshes the information

Views: Search Criteria

Input field and search option used to filter listed views by name, with optional inclusion of description text when the checkbox is enabled.

Search Criteria Settings

Settings	Description
View Search Input	Entered text used to filter the listed views by matching view names, and optionally descriptions when enabled.
Search Description	When unchecked, filtering is applied using only view names, excluding description text. When checked, view description text is included in the filtering criteria along with view names.

Create a New View

Creation of a new view initiated by selecting the icon, opening a blank view editor for entering view name, description, and SELECT query. After defining the query, selecting the Test Query option opens the SQL tab, where the query is executed and validated within the database context.

Create a New View Settings

Settings	Description
View Name	View name, reference the view within the database
Description	Entered value provides descriptive information associated with the defined database view.
Select Query/Test Query	Defined SQL SELECT statement determines the data returned by the view, and the Test Query action opens the SQL tab to execute and validate the query.
SELECT Query Editor	SQL SELECT statement entered and maintained to define the data structure and result set returned by the view when executed.

Edit Selected View

Editing an existing view initiated by selecting a view from the list and clicking the edit icon, opening the view editor populated with the current view name, description, and SELECT query. Modifications can then be applied directly to these fields, with the Test Query option available to validate changes within the SQL tab before saving.

Views: Column

List of defined database views presented with corresponding names and descriptions, enabling selection of a specific view for inspection, editing, or management within the database context.

Views: Column Settings

Settings	Description
View Name	Assigned name that uniquely identifies the view within the database and is used for referencing it.
Description	Associated text that provides additional information describing the content of defined view.