--分别修改就行了.注意字段的类型及其他属性.
alter table a alter column field1 varchar(100) not null
alter table a alter column field2 varchar(100) not null
alter table a alter column field3 varchar(100) not null
--分别修改就行了.注意字段的类型及其他属性.
alter table a alter column field1 varchar(100) not null
alter table a alter column field2 varchar(100) not null
alter table a alter column field3 varchar(100) not null
alter table a alter column field1 varchar(100) not null
alter table a alter column field2 varchar(100) not null
alter table a alter column field3 varchar(100) not null
--如果表里没有主键的话
alter table a add constraint pk_1 primary key (field1,field2,field2
create table aaa(field1 int,field2 int,field3 int)
go
alter table aaa alter column field1 int not null
alter table aaa alter column field2 int not null
alter table aaa alter column field3 int not null
go
alter table aaa add CONSTRAINT PK_aaa PRIMARY KEY CLUSTERED
(
[field1],
[field2],
[field3]
) ON [PRIMARY]
go
--写你实际的字段类型
alter table a alter column field1 varchar(100) not null
alter table a alter column field2 varchar(100) not null
alter table a alter column field3 varchar(100) not null
--如果表里没有主键的话
alter table a add constraint pk_1 primary key (field1,field2,field3)
alter table a alter column field1 varchar(100) not null
alter table a alter column field2 varchar(100) not null
alter table a alter column field3 varchar(100) not null
--如果表里没有主键的话
alter table a add constraint pk_1 primary key (field1,field2,field2)