34,837
社区成员




CREATE TABLE Test(id INT IDENTITY(1,1) PRIMARY KEY,name VARCHAR(10))
GO
INSERT INTO Test(name)
SELECT 'A'
UNION
SELECT 'B'
UNION
SELECT 'C'
SELECT *
FROM sys.indexes
WHERE object_id = ( SELECT object_id
FROM sys.tables
WHERE name = 'Test'
);
/*
结果中type =1 ,type_desc=CLUSTERED 是聚集索引哦.
*/