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

From dbscript Online Help
Jump to: navigation, search
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Sequence
 
| '''Sequence
 
| public.catnxtid
 
| public.catnxtid
|-
 
 
|}
 
|}
 
  
 
=== Sequence Properties ===
 
=== Sequence Properties ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| Min. Value
 
| Min. Value
 
| 1
 
| 1
|-
+
|- valign="top"
 
| Max. Value
 
| Max. Value
 
|  
 
|  
|-
+
|- valign="top"
 
| Start Value
 
| Start Value
 
| 1
 
| 1
|-
+
|- valign="top"
 
| Increment
 
| Increment
 
| 1
 
| 1
|-
+
|- valign="top"
 
| Cache Values
 
| Cache Values
 
| 1
 
| 1
|-
+
|- valign="top"
 
| Cycle
 
| Cycle
 
| false
 
| false
|-
 
 
|}
 
|}
 +
<pre>
 +
CREATE SEQUENCE public.catnxtid
 +
INCREMENT 1
 +
MINVALUE 1
 +
MAXVALUE 9223372036854775807
 +
START 1
 +
CACHE 1 NO CYCLE
 +
</pre>

Revision as of 23:38, 24 June 2010

wikibot

Sequence public.catnxtid

Sequence Properties

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