更改数据库表的结构
create table dbo.T_Department (
DepartCode varchar(4) not null,
DepartName nvarchar(20) null,
Telephone nvarchar(20) null,
Fathercode varchar(4) null,
IsForbid varchar(1) not null,
Remark nvarchar(200) null,
constraint PK_T_DEPARTMENT primary key nonclustered (DepartCode)
)
on "PRIMARY"
go
修改表添加列:
Alter table T_Department add [rowno] [int] IDENTITY (1, 1) NOT NULL
修改已有的列
Alter table T_Department Alter column [s_loginName] [nvarchar] (40) NULL
修改主键(由一个主键改成两个)
alter table T_Department drop constraint PK_T_DEPARTMENT
Alter table T_Department add [rowno] [int] IDENTITY (1, 1) NOT NULL ,
constraint PK_T_DEPARTMENT primary key (DepartCode,rowno)