Indexed views: Only possible with tables in the same database. Cross-database views: Possible, but not indexed and not schema-bound.

https://learn.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver17

No, you cannot create an indexed view from another view in SQL Server. Explanation Indexed views (views with a clustered index) must be schema-bound (WITH SCHEMABINDING). Schema-bound views can only reference base tables (not other views, functions, or synonyms). If you attempt to reference another view when creating a schema-bound view, SQL Server will return an error. 16.07.25

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2025