Display View Data Using Select Query

Select Column_Name

From View_Name;

Example-

                  

            Select * from mac1;

Create And Delete View

Creating View

          It just create duplicate table of original’s table and whole data (rows and columns) is same.In figure, View shown.

CREATE VIEW view_name As

SELECT Column_Names

FROM Table_Name

WHERE Conditions

Example-

                       

CREATE VIEW mac As

                        SELECT ename

                        FROM emp

                        WHERE empno=1;

                                                   Figure: suryagroops_001

Delete View

                    DROP VIEW view_name;

Through this query, we can delete view from views.

Example-

                   DROP VIEW mac;

Views

 

Views	1	In Sql Server, It is a virtual table.
	2	It contains fields from one or more real tables.
	3	It is generally used to join multiple tables and get the data
	4	It Illustrate data from many tables which can be used to generate reports.

ACID and View Properties

ACID Expand:-

ACID- Atomicity, Consistency, Isolation, Durability  

Properties of View Table(mac1)
 

Properties of View Column Table