示例6.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 9 行

CREATE VIEW student_index_03001_view
WITH SCHEMABINDING 
AS
SELECT Name,Numb
FROM dbo.student
WHERE Class = '03001' 
GO
CREATE UNIQUE CLUSTERED INDEX numb_index 
ON student_index_03001_view(Numb)