sybase数据库使用alter
sybase下使用alter：给一个表增加一个字段
alter table ATOM_STAGE.dbo.CSH_CASHBOOK add INTERFACE_STATUSFSCTextSmall default 'N'
删除字段
alter table ATOM_STAGE.dbo.CTL_TRADE_STATUS drop INTERFACE_STATUS
如果出现如下错误：
Cannot alter table 'CTL_TRADE_STATUS' because the database option 'allow nulls
by default' has been changed by concurrent users.
则要执行命令
sp_dboption ATOM_STAGE, "allow nulls by default", false
页:
[1]