일반 Using the H2 Database Sequence

황제낙엽 2011.03.23 06:06 조회 수 : 165

sitelink1  
sitelink2  
extra_vars5
extra_vars6 ko 

1. CREATE SEQUENCE [ IF NOT EXISTS ] newSequenceName [ START WITH long ] [ INCREMENT BY long ] [ CACHE long ]

 

2. DROP SEQUENCE [ IF EXISTS ] sequenceName

 

3. ALTER SEQUENCE sequenceName [ RESTART WITH long ] [ INCREMENT BY long ]

 

4. SELECT sequenceName.currval FROM DUAL

 

5. SELECT sequenceName.nextval FROM DUAL