我想修改表中的某一字段值,原来是char(20) Primary Key Not null我想改成Int用以下语句,但是报错,
Alter Table Table_Kind Alter Column KindNum int identity(1,1) Primary Key Not null
go
说是“在关键字 'identity' 附近有语法错误。”我的数据库是Sql2000谢谢!
Alter Table Table_Kind Alter Column KindNum int identity(1,1) Primary Key Not null
go
说是“在关键字 'identity' 附近有语法错误。”我的数据库是Sql2000谢谢!
去掉用
ALTER TABLE Table_Kind
DROP CONSTRAINT PK_Table_Kind
ALTER TABLE Table_Kind ADD CONSTRAINT
PK_Table_Kind PRIMARY KEY CLUSTERED
(
KindNum
) ON [PRIMARY]
连起来就是ALTER TABLE Table_Kind
DROP CONSTRAINT PK_Table_KindAlter Table Table_Kind Alter Column KindNum int Not nullALTER TABLE Table_Kind ADD CONSTRAINT
PK_Table_Kind PRIMARY KEY CLUSTERED
(
KindNum
) ON [PRIMARY]