EMS logo

Produits

SQL Manager for SQL Server

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

Documentation en ligne

Views


A View is a logical table based on one or more tables or views. A view contains no data itself. The tables upon which a view is based are called base tables.

 

Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a subset of a particular table).

 

 

View Editor allows you to create new views and define their properties (view name and the SELECT statement it implements). It opens automatically when you create a new view and is available on editing an existing one.

 

To open a view in View Editor, double-click it in the DB Explorer tree.