articles

Home / DeveloperSection / Articles / Views in SQL Server

Views in SQL Server

Anonymous User7507 18-Jul-2011
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



Updated 04-Mar-2020
I am a content writter !

Leave Comment

Comments

Liked By