请问删除一个主键再建立一个的语句如何写？

[junglesong]

ALTER TABLE D_KOSYO_H Drop CONSTRAINT PK_D_KOSYO_H
go

alter table D_KOSYO_H WITH NOCHECK ADD
CONSTRAINT [PK_D_KOSYO_H] PRIMARY KEY CLUSTERED
([KOSYO_NO]
) ON [PRIMARY]
GO

这样写对吗？

[yaoyaomaomao]

删除:
ALTER TABLE D_KOSYO_H Drop CONSTRAINT PK_D_KOSYO_H
go
添加:
alter table D_KOSYO_H
ADD
CONSTRAINT [PK_D_KOSYO_H] PRIMARY KEY CLUSTERED
([KOSYO_NO]
go

[mxc1974]

--删除表
DROP TABLE [A]
GO

--建立表
CREATE TABLE [A] (
[ID] [int] NOT NULL ,
[NAME] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO

--删除主键:
ALTER TABLE A Drop CONSTRAINT PK_A
GO

--添加主键:
ALTER TABLE A
ADD
CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED
([ID])
GO