"Be the change that you want to see in the world."
- Mahatma Gandhi
CREATE View Employee_V AS
FROM Employee_Table ;
The purposes of views is to restrict access to certain columns, derive columns or Join Tables, and to restrict access to certain rows (if a WHERE clause is used). This view does not allow the user to see the column salary.
CREATE VIEW Employee_View