sql

【例7．2】
USE Xk
GO
CREATE UNIQUE CLUSTERED
INDEX IX_StuNoCouNo ON StuCou (StuNo,CouNo)
GO

【例7．4】
USE Xk
GO
DROP INDEX StuCou.IX_StuNoCouNo
GO

【例7．5】
USE Xk
GO
DROP INDEX Student.PK_Student
GO

【例7．6】
USE Xk
GO
EXEC sp_helpindex Student
GO

【例7．7】
USE Xk
GO
EXEC sp_rename 'Student.IX_StuName','IX_StuNameNew'
GO

【例7．8】
Use Xk
GO
SET SHOWPLAN_ALL ON
GO
SELECT * FROM Student WHERE StuName='林斌'
GO
SET SHOWPLAN_ALL OFF
GO

【例7．9】
Use Xk
GO
SET SHOWPLAN_ALL ON
GO
SELECT * FROM Student WHERE StuNo='00000001'
GO
SET SHOWPLAN_ALL OFF
GO

【例7．10】
Use Xk
GO
SET STATISTICS IO ON
GO
SELECT * FROM Student WHERE StuName='林斌'
GO
SET STATISTICS IO OFF
GO

【例7．12】
USE Xk
GO
UPDATE STATISTICS Student PK_Student
GO

【例7．13】
USE Xk
GO
DBCC SHOWCONTIG (Student,PK_Student)
GO

【例7．14】
DBCC INDEXDEFRAG (Xk,Student,PK_Student)
GO

【例7．17】
USE Xk
GO
ALTER TABLE StuCou
ADD CONSTRAINT IX_StuNoCouNo PRIMARY KEY (StuNo,CouNo)
GO

【例7．18】
USE Xk
GO
ALTER TABLE StuCou
DROP CONSTRAINT IX_StuNoCouNo
GO

【例7．19】
USE Xk
GO
ALTER TABLE StuCou
ADD CONSTRAINT StuNo_FK FOREIGN KEY (StuNo)
REFERENCES Student (StuNo)
GO

【例7．20】
USE Xk
GO
ALTER TABLE StuCou
DROP CONSTRAINT STuNo_FK
GO

【例7．23】
USE Xk
GO
CREATE UNIQUE INDEX IX_Pwd ON Student (Pwd)
GO

【例7．24】
USE Xk
GO
ALTER TABLE Student
ADD CONSTRAINT CK_StuNo CHECK (StuNo like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
GO

【例7．25】
USE Xk
GO
ALTER TABLE Student
DROP CONSTRAINT CK_StuNo
GO

【例7．26】
USE Xk
GO
ALTER TABLE StuCou
ADD CONSTRAINT CK_WillOrder CHECK (WillOrder>=1 AND WillOrder<=5)
GO

【例7．29】
USE Xk
GO
ALTER TABLE StuCou
ADD CONSTRAINT DF_StuCou_State DEFAULT ('报名') FOR State
GO

【例7．30】
USE Xk
GO
ALTER TABLE StuCou
DROP CONSTRAINT DF_StuCou_State
GO