先删掉旧的:declare @a varchar(20)select @a=c.name from syscolumns a,sysconstraints b,sysobjects c where a.id=object_id('表名') and a.name='主鍵列名' and a.id=b.id and b.constid=c.id and c.name like 'PK%'exec('alter table 表名 drop constraint '+@a)
调试欢乐多
按要求就行了
2应该是alter table tableA moDify col1 primary key
1我是不太明白sql该怎么写
2刚才打错了不好意思,我在分析器里写得和你一样,有错误。
例如:
ALTER TABLE [dbo].[Db_name] WITH NOCHECK ADD
CONSTRAINT [PK_Db_name] PRIMARY KEY CLUSTERED
(
[Col1],
[Col2]
) ON [PRIMARY]
GO
( [col1]) ON [PRIMARY]