View creation syntax : View « View « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. View
  3. View
CREATE VIEW <view name>
AS
<SELECT statement>

The above syntax just represents the minimum, of course, but it's still all we need in a large percentage of the situations. The more extended syntax looks like this:
CREATE VIEW <view name> [(<column name list>)]
[WITH [ENCRYPTION] [,SCHEMABINDING] [, VIEW_METADATA]]
AS
<SELECT statement>
WITH CHECK OPTION








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