示例6.sql

SQL基础教程上的一些源码

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)