Difference between revisions of "Public.catnxtid (sequence)"

From dbscript Online Help
Jump to: navigation, search
 
Line 11: Line 11:
 
|- valign="top"
 
|- valign="top"
 
| Min. Value
 
| Min. Value
| 1
+
|  
 
|- valign="top"
 
|- valign="top"
 
| Max. Value
 
| Max. Value
Line 17: Line 17:
 
|- valign="top"
 
|- valign="top"
 
| Start Value
 
| Start Value
| 1
+
|  
 
|- valign="top"
 
|- valign="top"
 
| Increment
 
| Increment
| 1
+
|  
 
|- valign="top"
 
|- valign="top"
 
| Cache Values
 
| Cache Values
| 1
+
|  
 
|- valign="top"
 
|- valign="top"
 
| Cycle
 
| Cycle
| false
+
|  
 
|}
 
|}
 
<pre>
 
<pre>
 
CREATE SEQUENCE public.catnxtid
 
CREATE SEQUENCE public.catnxtid
INCREMENT 1
+
INCREMENT  
MINVALUE 1
+
MINVALUE  
MAXVALUE 9223372036854775807
+
MAXVALUE  
START 1
+
START  
CACHE 1 NO CYCLE
+
CACHE CYCLE
 
</pre>
 
</pre>

Latest revision as of 10:19, 27 August 2011

wikibot[edit]

Sequence public.catnxtid

Sequence Properties[edit]

Min. Value
Max. Value
Start Value
Increment
Cache Values
Cycle
CREATE SEQUENCE public.catnxtid
INCREMENT 
MINVALUE 
MAXVALUE 
START 
CACHE  CYCLE