ALTER VIEW [dbo].[Vw_View1] WITH SCHEMABINDING AS
SELECT ...
FROM ...
CREATE UNIQUE CLUSTERED INDEX [IX_Index1] ON [dbo].[Vw_View1]
(
[Column1] ASC
)
GO
related errors:
Cannot create index on view because the view is not schema bound.
http://www.mssqltips.com/tip.asp?tip=1610
indexed view with schemabinding
Gönderen
pantepember
15 Eylül 2010 Çarşamba