Home > DeveloperSection > Articles > Views in SQL Server

Views in SQL Server


Database Database 
Ratings:
0 Comment(s)
 3554  View(s)
Rate this:

Views in SQL Server

Views:

Views contain row and column as table contains. The fields in a view are fields from one or more real tables in the database. You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

Syntax: Creating Views in SQL server

---- SYNTAX CREATING VIEWS IN SQL SERVER

CREATE VIEW <VIEWNAME>

AS

----DATA SELECT FROM TABLE

---SELECT STATEMENT FOR SELECTING VALUE

Example: Creating view in SQL

---- DEMONSTRATION FOR CREATING VIEWS IN SQL SERVER

CREATE VIEW TESTVIEWCONCEPT

AS

SELECT * FROM userlogininfo

Syntax: Update views

----SYNTAX TO UPDATE VIEW IN SQL SERVER

CREATE OR REPLACE VIEW <VIEW_NAME>

AS

---- SELECT MODIFIED QUERY FROM DATABASE TABLE

Example: Updating Views in SQL server

---- DEMONSTRATION OF UPDATE VIEW IN SQL SERVER

CREATE OR REPLACE VIEW TESTVIEWCONCEPT

AS

SELECT * FROM userlogininfo WHERE UserName LIKE 'AR%'

Syntax: Drop Views from SQL Server

-----DEMONSTRATION TO DROP VIEWS FROM SQL SERVER

DROP VIEW <VIEW_NAME>

Example: Drop Views from SQL server

-----DEMONSTRATION TO DROP VIEWS FROM SQL SERVER

DROP VIEW TESTVIEWCONCEPT

Views with multiple table statement:

Syntax: Creating Views with multiple select query

---- SYNTAX CREATING VIEWS WITH MULTIPLE SELECT STATEMENT IN SQL SERVER

CREATE VIEW <VIEWNAME>

AS

--SELECT FIRST STATEMENT

UNION ALL

--SELECT SECOND STATEMENT

UNION ALL

-- SELECT THIRD STATEMENT

..............

..............

Example: Creating View with multiple select query

---- DEMONSTRATION OF CREATING VIEW WITH MULTIPLE TABLE STATEMENT

CREATE VIEW MULTIVIEW

AS

SELECT * FROM ClientInfo UNION ALL

SELECT * FROM  DUPLICATE


Don't want to miss updates? Please click the below button!

Follow MindStick