系统表sys.syscolpars相关

因为发现对象名称 'sys.syscolpars' 和索引名称 'nc' 有重复的键，所以 CREATE UNIQUE INDEX 语句终止。重复的键值为 (ModuleDefID, 1300876397, 0) name id number

select * from sys.syscolpars where id=1300876397

SELECT name FROM sys.indexes WHERE object_id = OBJECT_ID('sys.syscolpars');

-- 首先，禁用索引

ALTER INDEX NC ON sys.syscolpars DISABLE;

-- 然后，重建索引

ALTER INDEX NC ON sys.syscolpars REBUILD;

-- 最后，重新启用索引

ALTER INDEX YourIndexName ON YourTableName ENABLE;

EXEC sp_msforeachtable 'UPDATE STATISTICS ?';
-- 或者清理缓存
DBCC FREEPROCCACHE;
DBCC DROPCLEANBUFFERS;

-- 查看 sys.syscolpars 的索引信息
SELECT 
 i.name AS index_name,
 i.type_desc AS index_type,
 ISNULL(c.name, 'N/A') AS column_name
FROM sys.indexes i
JOIN sys.objects o ON i.object_id = o.object_id
LEFT JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
LEFT JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE o.name = 'syscolpars'
ORDER BY i.index_id, ic.key_ordinal;