删除:
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
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
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