각각 디비 시퀀스 생성

1. Oracle

생성

CREATE SEQUENCE  "SEQ_FORUM" 

 MINVALUE 1 MAXVALUE 99999999999999999999 INCREMENT BY 1

START WITH 1 CACHE 20 NOORDER  NOCYCLE

확인

SELECT SEQ_FORUM.NEXTVAL FROM DUAL

 

2. MS-SQL

생성
IF EXISTS
   (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='SEQ_FORUM')
DROP TABLE [dbo].[SEQ_FORUM];

 

CREATE TABLE [dbo].[SEQ_FORUM] (
[ID] decimal(18, 0) IDENTITY(0, 1) NOT NULL)
ON [PRIMARY];

확인

SELECT (IDENT_CURRENT('SEQ_FORUM') + 1) AS NEXTVAL

 

3.MySQL

생성

DROP TABLE IF EXISTS  SEQ_FORUM ;

CREATE TABLE SEQ_FORUM (
  ID bigint(8) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (ID)
) ENGINE=MyISAM AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;

확인

SELECT MAX(SEQ_FORUM)+1 AS NEXTVAL FROM FORUM

출처 : http://blog.naver.com/webdilh?Redirect=Log&logNo=30118690170 

[출처] Oracle, MS-SQL, MySQL 시퀀스생성|작성자 꽥꽥