sp_helpconstraint 其中也有主键约束, 你也想去掉吗?如果是: DECLARE @name VARCHAR(30)DECLARE tcur CURSOR FOR SELECT object_name(constid) FROM sysconstraints s INNER JOIN sysobjects so ON so.id = s.id WHERE so.name = 'lxm_info'OPEN tcur FETCH NEXT FROM tcur INTO @nameWHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE [dbo].[lxm_info] DROP CONSTRAINT ' + @name) FETCH NEXT FROM tcur INTO @name ENDCLOSE tcur DEALLOCATE tcur GO 如果你不想drop主键, 那就在WHERE里加条件吧.
DECLARE @name VARCHAR(30)DECLARE tcur CURSOR FOR
SELECT object_name(constid)
FROM sysconstraints s
INNER JOIN sysobjects so
ON so.id = s.id
WHERE so.name = 'lxm_info'OPEN tcur
FETCH NEXT FROM tcur INTO @nameWHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE [dbo].[lxm_info] DROP CONSTRAINT ' + @name) FETCH NEXT FROM tcur INTO @name
ENDCLOSE tcur
DEALLOCATE tcur
GO
如果你不想drop主键, 那就在WHERE里加条件吧.