Hello,
I have a view created from a Pivot. I am trying to create an index on this view but get the following error: Cannot create index on view 'testview' because the view is not schema bound.
It is possible to create an index on view which is created from a pivot?
Thanks
David
Here is the full error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Index 'IDX_test'. (Microsoft.SqlServer.Smo)
Cannot create index on view 'testview' because the view is not schema bound. (Microsoft SQL Server, Error: 1939)
For help, click:
I have a view created from a Pivot. I am trying to create an index on this view but get the following error: Cannot create index on view 'testview' because the view is not schema bound.
It is possible to create an index on view which is created from a pivot?
Thanks
David
Here is the full error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Index 'IDX_test'. (Microsoft.SqlServer.Smo)
Cannot create index on view 'testview' because the view is not schema bound. (Microsoft SQL Server, Error: 1939)
For help, click: