A view can be defined for any DBMS that supports them; views can be generated and reverse engineered. There are two ways to create a database view in System Architect.
You can generate a view on any table without an explicit view definition through the Schema Generator dialogue.
You can create a view on more than one table or a view on a portion of one or more tables, through an explicit view definition.
1 Right-click Definitions in the explorer, and then click New.
2 From the list of possible definitions, select SQL Server View (or DB2 View, and so on.)
3 Enter the View name, name of the model, database and owner in the Dictionary Object dialog box.
The model and database must match those of the physical data model whose tables you intend to generate.
4 In the View definition dialog box, enter the column names in Column names, and the SELECT statement in Select Statement.
Example
To create a view from some columns from the table Employee, some from the table Hotel, and some from the table Manager:
1 In Column names, enter:
Emp_ID,First_Name,Family_Name,Hotel,City,Title
2 In Select Statement, enter:
SELECT Employee.Employee_ID, Employee.Employee_First_Name, Employee.Employee_Family_Name, Hotel.Hotel_Name, Hotel.City, Manager.Title FROM Employee,Hotel,Manager