View in Sql Server


View in Sql Server

  • View is a virtual table
  • It s contains columns and data in different table
  • View does not contain any data directly. Its a set of select query
Table 1

Sno
Sname
Table 2
Sno
Lname
             
View_table1_table2

Sname
Lname

Above drawing table 1 and table we will write join query after we can create view

Syntax

CREATE VIEW JS_VIEW_NAME
AS
[SELECT STATEMENT]

Why we are use View ?
 View is used for security mechanism .if you restricted particular column for users .

Sql Server Syntex for View
CREATE VIEW
CREATE VIEW JS_VIEW
AS
SELECT *FROM STUD A,LIB L WHERE A.SNO=L.SON
ALTER VIEW
ALTER VIEW JS_VIEW
AS
SELECT *FROM STUDENTTABLE A,LIB L WHERE A.SNO=L.SON
SELECT VIEW
SELECT*FROM JS_VIEW
DROP VIEW:
DROP VIEW JS_VIEW

0 Comments

Featured Post

Understanding about Azure Region, Geographies, Availability Zones and Region Pairs

Introduction Microsoft Azure services are available in 53 regions around the world, with plans announced for 7 additional regions and 140+ a...

Subscribe to the FREE Weekly Newsletter to receive all the latest Microsoft Azure, AI, Xamarin

Popular Posts