Indexed views

[ramcperi]

i am trying to create an index on a table with 2 derived cilumns.

Like Pro_type 'UN' = 'Unified'

+ all the existing columns of the base table.

when i create the view WITH SCHEMABINDING - TO FURHTER CREATE A UINIQUE CLUSTERED INDEX..

THIS IS THE ERROR,

CAN U PLEASE HELP ME... URGENT.

Server: Msg 4512, Level 16, State 3, Procedure VW_Prod_HIERARCHY_D, Line 3
Cannot schema bind view 'VW_Products' because name 'Products' is invalid for schema binding.
Names must be in two-part format and an object cannot reference itself.

[Rawhide]

Well the two-part name would be in the format of: owner.table

So you need to reference it as dbo.Products (or whoever the owner is).

The calculated fields can't reference themselves or their parent object.