Create and Manage Views in SQL Server

Question

Hi friends I want to know that how to create and manage views in SQL Server. Please explain it with example. Thank you

Jignesh Trivedi · Answer

hi to create view MSSQL use following syntax CREATE VIEW Customers AS SELECT col1col2col3 FROM Table1 UNION ALL SELECT col1col2col3 FROM table2 To manaview use ALTER statement. hope this help.

Senthilkumar · Answer

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 Normal or Standard view Indexed or permanent view 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/

Satyapriya Nayak · Answer

Hi Vipendra Please refer the below link http://www.codeproject.com/Articles/38560/Overview-of-View-in-SQL-Server-2005 Thanks