Create and Manage Views in SQL Server

hi,

to create view MSSQL use following syntax,

CREATE VIEW Customers
AS
SELECT col1,col2,col3 FROM Table1
UNION ALL
SELECT col1,col2,col3 FROM table2

To manaview use ALTER statement.

hope this help.

Hi,

The view is a virtual table, which can have the multiple columns from the one or more table. It can be used like the normal table. Normally view cannot store the data permanently in the table. When we create the view it stores the view definition schema as object under the concern database.

Let us see the syntax of the create view

CREATE VIEW View Name [Alias name1, name2,]

WITH ENCRYPTION

WITH SCHEMA BINDING

AS

SELECT statement [WITH CHECK OPTION]

The create view can be created with the view name and the alias can be given in the view name parameter parenthesis. The view schema can be stored in the encrypted format. Here is an option like SCHEMA BINDING; this is an important mile stone in the view to allow the developers to create the permanent view.

There are three types of views in the sql server 2005.

They are 

1. Normal or Standard view
2. Indexed or permanent view
3. Partitioned view

I have written a article with lot of examples. you go here.

http://www.c-sharpcorner.com/uploadfile/skumaar_mca/views-in-sql-server-2005/ 

Hi Vipendra,


Please refer the below link


http://www.codeproject.com/Articles/38560/Overview-of-View-in-SQL-Server-2005

Thanks