Views with CHECK OPTION

A view is a way of representing data without the need to store and maintain it. A view is not an actual table and requires no storage. It also provides a different way of looking at the data in one or more base tables.

For example, if you want to restrict users from accessing SSN and SALARY information, you can easily do so by creating a view without these columns and limit the user's access to only the view. An example of this is shown as follows:

CREATE TABLE demo.employee ( 
                  empid INTEGER, 
                  name VARCHAR(30), 
                   ssn  VARCHAR(11), 
                  salary INTEGER ); 
 
SELECT * FROM demo.employee; 
 
EMPID       NAME               SSN         SALARY 
----------- ------------------- ---------------- ----------- 
          1 Robert, Colin     999-99-9999       90000 
          2 Milan, Mohan    ...