sybase如何增长表中的字段长度？

lvchh

我现在用的11.0.3， 我用了1> alter table biaoming modify (regno char(25))
2> go
Msg 102, Level 15, State 1:
Line 1:
Incorrect syntax near 'modify'.
1>

hobbylu

alter table biaoming modify regno char(25) null/not null

ljlfromjj

1>  alter table cpddd modify bz char(20) null
2> go
Msg 11052, Level 16, State 1:
Line 1:
The 'select into' database option is not enabled for database 'fydb'. ALTER
TABLE with data copy cannot be done. Set the 'select into' database option and
re-run.

leno_mx

fydb数据库属性勾上。

action929

sp_dboption fydb, 'select into/bulkcopy', true
go