View in Sql Server

Posted by Suthahar on Sunday, May 15, 2011 No comments

Labels SQL

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

Tags SQL

Suthahar

Suthahar Jegatheesan is Mobile and Cloud Specialist/Architect and he has 15+ years of IT experience as a Technology Consultant /Programmer/Developer in IT industry. Suthahar is an industry luminary focused on AI, Computer Vision, Bot, Machine Learning, UWP, Azure, Xamarin and Web Emerging User Experiences as subject matter expert (SME) in implementation, architecture, development and administration.

About Suthahar →

View in Sql Server