Cannot create index on view 'View_Table_Name' because the view is not schema bound Cannot create index on view 'View_Table_Name' because the view is not schema bound sql-server sql-server

Cannot create index on view 'View_Table_Name' because the view is not schema bound


There are a number of restrictions on indexed views: no subqueries, no unions, no outer joins, etc. See this article for more details. But for your case, you simply need to create the view with schema binding.

CREATE VIEW VW_Table_Name WITH SCHEMABINDINGASSELECT Col1,Col2,Col3 FROM Table_Name GO


Because you are trying to create an Indexed View or Materialized View. Its mandatory for a view to have "WITH SCHEMABINDING" option if you are creating a Clustered Index on top of it.

A view is nothing but a stored query, if you are going to create an index on it, then the index is going to use that query and execute it on that table, in this case you have to make sure that the table does not change underneath. Thus by enforcing this constraint SQL Server makes sure everything remains in sync.