- 论坛徽章:
- 0
|
原帖由 smithy 于 2006-5-26 10:06 发表
使用默认的情况咯
如果不加definition only 是会报错的
------------------------------------------------------
还有个问题,如果对已一个已有数据的table添加一个“自动增加列”,请问语句该怎么写,下面的语句,会报错。
alter table ww add column id INT not null GENERATED ALWAYS AS IDENTITY(start with 0,increment by 1,no cache),primary key(id)
报错信息:
The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0104N An unexpected token "," was found following "ement by 1,no cache)".
Expected tokens may include: "<space>". SQLSTATE=42601 |
|