在Sybase数据库创建表时,对于自动增长字段的写法示例:
CREATE TABLE dbo.BM_SM_ERR
(
SMCWBM int identity, -- 表主键
SMCWDM varchar(10) NOT NULL,
YYSLX smallint NOT NULL,
SMCWMS varchar(100) NOT NULL,
QYBJ tinyint DEFAULT 1 NOT NULL,
CONSTRAINT PK_BM_SM_ERR
PRIMARY KEY CLUSTERED (SMCWBM)
)
with identity_gap=1
go