The syntax of the CREATE VIEW statement : Create View « View « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. View
  3. Create View
CREATE VIEW view_name [(column_name_1 [, column_name_2]...)]
[WITH {ENCRYPTION|SCHEMABINDING|ENCRYPTION,SCHEMABINDING}]
AS
select_statement
[WITH CHECK OPTION]








16.2.Create View
16.2.1.The syntax of the CREATE VIEW statement
16.2.2.A view is a SELECT statement that's stored with the database.
16.2.3.WITH SCHEMABINDING clause protects a view by binding it to the database structure, or schema.
16.2.4.Views have a couple of limitations.
16.2.5.Create a view based on correlated subquery and then query it
16.2.6.Encrypting aView
16.2.7.A CREATE VIEW statement that uses TOP and ORDER BY clauses
16.2.8.Creating an Indexed View (CLUSTERED, NONCLUSTERED)
16.2.9.Using the ORDER BY Clause in a View with TOP 100 PERCENT
16.2.10.Supplying Column Names in the Header of the View