7.1.5.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 12 行

USE SCHOOL
GO
DECLARE @name VARCHAR(20)
SELECT @name=name FROM sysindexes WHERE id=object_id('test')
EXEC('alter table TEST drop constraint '+@name)
GO
ALTER TABLE TEST WITH NOCHECK ADD 
	CONSTRAINT [PK_ID] PRIMARY KEY NONCLUSTERED([ID])
GO
CREATE CLUSTERED INDEX IX_NAME ON TEST(NAME)
GO