摘要： 1、删除主键ALTER TABLE TableName DROP CONSTRAINT PKname2、改字段长度ALTER TABLE TableName ALTER COLUMN PKcolname char(15) NOT NULL3、恢复主键ALTER TABLE [dbo].[TableName] WITH NOCHECK ADD CONSTRAINT [PKname] PRIMARY KEY CLUSTERED ([PKcolname]) ON [PRIMARY] 阅读全文