1. 表中添加字段语句
点击查看代码
alter table TableName add FileName varchar(36)
2. 修改表中字段长度
点击查看代码
ALTER TABLE SupplierLog ALTER COLUMN Remark varchar(1000);
3. 创建表
点击查看代码
create table SupplierLog(
Autoid int primary key identity(1,1) not null,
SupplierName varchar(50),
SupplierID varchar(30),
LogType int,
Remark varchar(200),
LogDateTime datetime,
)