EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Creating/editing view

Use the View tab of View Editor to create/edit a view and specify its definition.


This tab represents the view definition as SQL statement, hence it is enough to simply edit the whole definition using the editor area to make appropriate changes, and recompile the view.


For your convenience the syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with SQL Editor area and Using the context menu.


View Editor - Editing view definition



To compile a view, you can use the iconCompile Compile item available within the Navigation bar.