给视图增加索引时,如果提示错误:
无法将 视图'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