I am using SQL server 2005. I have tons of view which I am using as virtual tables. I want to create index on view. I tried to run it. got error msg. Please note that my both views are POH and POD
Cannot schema bind view 'vwakview'. 'dbo.POD' is not schema bound.
create view vwakview
with schemabinding
as
SELECT POH.AEDAT, POH.LIFNR, POD.PO, POH.TERM1, POH.TERM2, POD.DC, POD.SITE, POD.QTY, POD.WEIGHT, POD.VOLUM
from dbo.POD
INNER JOIN dbo.POH
ON
(dbo.POH.MANDT = dbo.POD.MANDT AND dbo.POD.PO= dbo.POH.PO)