alter table talbe1 add xuhao int
go
alter table table1 add CONSTRAINT PK_table1 PRIMARY KEY NONCLUSTERED (xuhao)
go
go
alter table table1 add CONSTRAINT PK_table1 PRIMARY KEY NONCLUSTERED (xuhao)
go
CREATE TABLE
( C0 INTEGER IDENTITY (1,1),
PRIMARY KEY C0)
alter table yourtablename
add xuhao int not null
constraint xuhao_id primary key(xuhao)若有数据,则
alter table yourtablename
add xuhao identity(1,1) int not null
constraint xuhao_id primary key(xuhao)
go
alter table table1 add CONSTRAINT PK_table1 PRIMARY KEY NONCLUSTERED (xuhao)
go愉快的登山者 ⊙
◢◣◢◣◢◣
create table table_name (xh number(2),item varcahr2(10),
constraint pk_table_name primary key(xh));