Sybase IQ 自增序列恢复

 

 

 

CREATE TABLE mytable(c1 INT IDENTITY);
SET TEMPORARY OPTION IDENTITY_INSERT ="DBA".mytable;
INSERT INTO mytable VALUES(5);