How to create a view

How to create a view

Step 1

To create a view go to Enterprise Manager, select the database that your view would reside and then right click on view

Then another window will appear

Step 2

Click on Add Table and another window appear. Here you need to select Employees table and click on Add

Step 3

Select Employees table and click on Add

Step 4

Under the Column choose Employee_id and then for its criteria enter the value 2.

Step 5

Notice that the SQL query will change accordingly.

Click on the red exclamation mark to run it.

Step 6

To save your View just click on the floppy icon on your top left hand side.