VIEWS ARE STORED named SELECT statements. : View « View « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. View
  3. View
Views are not a copy of your data.
Views have the look and feel of a table.
You can, with certain limitations, issue all DML statements against a view.
When you issue a query against a view, it is internally merged with the underlying 
SELECT statement and then issued against the base table or tables.








16.1.View
16.1.1.VIEWS ARE STORED named SELECT statements.
16.1.2.View creation syntax
16.1.3.A view is a SELECT statement that's stored with the database.
16.1.4.Create and query a view
16.1.5.View with check option
16.1.6.Join syscomments and sysobjects to query a view
16.1.7.Create a view to wrap a long sql statement
16.1.8.Setting Permissions on a View