SQL Server中创建视图索引

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

--表名包含模式名。 
--包含 WITH  SCHEMABINDING 语句 

CREATE VIEW dbo.v_Customer WITH SCHEMABINDING AS  
SELECT  CustomerID, CompanyName, FirstName, LastName, Picture   
FROM  dbo.Customers