给视图增加索引时,如果提示错误:

无法将 视图'dbo.v_batch_index' 绑定到架构,因为名称t_im_batmas对于架构绑定无效。名称必须由两部分构成,并且对象不能引用自身。

改进方法:视图里用到的表,前面必须加dbo,如:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v_batch_index]') and OBJECTPROPERTY(id, N'IsView') = 1)
 drop view [dbo].[v_batch_index]
 GOCREATE VIEW dbo.v_batch_index WITH SCHEMABINDING
 ASSELECT t.product_code,t.product_name,t.batch_no,stock_type
 FROM dbo.t_im_batmas t 
 INNER JOIN dbo.product p ON t.product_code = p.product_codeGO
CREATE UNIQUE CLUSTERED INDEX IDX_v_master1
    ON v_batch_index (product_code, batch_no);
 GO