Views are database objects that provide a stored query result, presenting data from one or more tables in a structured way without storing the data itself. They are commonly used to simplify complex queries or enhance security by restricting access to specific data.

SqlDBM enables users to create, export, and import views. You can also use the Compare Revisions feature to identify differences between your views, along with the Alter Script feature to incorporate changes.

Views support in SqlDBM:

Views are available for the following SqlDBM project types:

SqlDBM provides customers with a SQL editor to create and modify views. To access the editor, please follow the following steps:

(1) Click on the “Database Explorer” menu icon in the left menu bar

(2) Select “Views” in the list of objects

(3) Click “+ Create new” or select one of the existing views in the list.

You can also bring your existing views from the database to SqlDBM. SqlDBM Reverse Engineering feature allows to bring views in two different ways:

(1) Directly connect to a database environment to bring the objects

(2) Copy and paste the view definitions from your database to SqlDBM

You can identify differences between your views in SqlDBM revisions and use the Alter script to incorporate the changes. Follow the steps below to access these features:

To Compare:

(1) Click on the “Compare revisions” menu icon in the left menu bar

(2) Select two revisions between which you want to identify the changes in your view definition

To Alter:

(1) Click on the “Reverse Engineer — Generate SQL” menu icon in the left menu bar

(2) Click “Generate Alter SQL”

This feature is not supported for all license types.

Views can be connected/related to other objects on a diagram using virtual relationships. These can be detected automatically through the "Analyze all views" action, or manually, through virtual relationship creation.

Create a virtual relationship automatically through the "Analyze all views" action:

To create a manual virtual relationship, select a virtual relationship type from the top menu of the diagram, then click and drag from the view to the target object.

Virtual connections can be made between any objects on the diagram (views, tables, functions, or procedures).

View properties can be maintained in the right-hand properties panel when a view is selected on the diagram or Diagram/Database Explorer list.

The following properties are available: