--建立测试环境 IF OBJECT_ID('tb') IS NOT NULL DROP TABLE tb GO CREATE TABLE tb ( id int identity, code varchar(10), name varchar(20), CONSTRAINT PK_TB PRIMARY KEY NONCLUSTERED (id) ) GOCREATE CLUSTERED INDEX [IX_tb] ON [dbo].[tb] ( [code] ASC )WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] godrop index tb.ix_tb
CONSTRAINT PK_...
IF OBJECT_ID('tb') IS NOT NULL DROP TABLE tb
GO
CREATE TABLE tb
(
id int identity,
code varchar(10),
name varchar(20),
CONSTRAINT PK_TB PRIMARY KEY NONCLUSTERED (id)
)
GOCREATE CLUSTERED INDEX [IX_tb] ON [dbo].[tb]
(
[code] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
godrop index tb.ix_tb