ALTER SEQUENCE
目录
ALTER SEQUENCE
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
EXAMPLES ä¾å
NOTES 注æ
COMPATIBILITY å¼å®¹æ§
SQL99
è¯è
è·
NAME
ALTER SEQUENCE - æ´æ¹ä¸ä¸ªåºåçæå¨çå®ä¹
SYNOPSIS
ALTER SEQUENCE
name [ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE
maxvalue | NO MAXVALUE ]
[ RESTART [ WITH ] start ] [ CACHE cache ] [ [
NO ] CYCLE ]
DESCRIPTION æè¿°
ALTER SEQUENCE å½ä»¤ä¿®æ¹ä¸ä¸ªç°æçåºååçå¨çåæ°ã ä»»ä½æ²¡ææç¡®å¨ ALTER SEQUENCE å½ä»¤é声æçåæ°é½å°ä¿çååç设置ã
PARAMETERS åæ°
|
name |
ä¸ä¸ªè¦ä¿®æ¹çåºåçååï¼å¯ä»¥æ模å¼ä¿®é¥°ï¼ã
increment
INCREMENT BY increment åå¥æ¯å¯éçãä¸ä¸ªæ- £æ°ä¼è®©åºåæ为éå¢åºåï¼è´æ°åæ为éååºåã å¦æ没æ声æï¼å°æ²¿ç¨åæ¥çéå¢å¼ã
minvalue
NO MINVALUE
å¯éçåå¥ MINVALUE minvalue å³å®ä¸ä¸ªåºåå¯ä»¥çæçæå°çå¼ãå¦æ声æäº NO MINVALUEï¼å°ä½¿ç¨ç¼ºçå¼ï¼ 对äºéå¢åéåçåºååå«æ¯ 1 å -2ˆ63-1ãå¦æ没æ声æä»»ä½é项ï¼å沿ç¨å½åçæå°å¼ã
maxvalue
NO MAXVALUE
å¯éçåå¥ MAXVALUE maxvalue å³å®åºåçæ大å¼ãå¦æ声æäº NO MAXVALUEï¼å使ç¨ç¼ºçå¼ï¼å¯¹äºéå¢åéåçåºååå«æ¯ 2ˆ63-1 å -1ãå¦æ两个é项é½æ²¡æ声æï¼ å沿ç¨å½åçæ大å¼ã
|
start |
å¯éç RESTART WITH start åå¥å许åºåå¯ä»¥å¨ä»»ä½å°æ¹å¼å§ã
|
cache |
CACHE cache é项æå¼åºåå·é¢åé并åå¨å¨ååç¼å²çåè½ãæå°å¼æ¯ 1 ï¼ä¹å°±æ¯æ¯æ¬¡åªè½çæä¸ä¸ªæ°å¼ï¼æ²¡æç¼å²ï¼ã å¦æ没æ声æï¼å°æ²¿ç¨æ§çç¼å²å¼ã | ||
|
CYCLE |
å¯éçé®å CYCLE å¯ä»¥ç¨äºå许åºåå¨è¾¾å°éå¢åºåç maxvalue æèéååºåç minvalueçæ¶åéå 使ç¨ã å¦æè¾¾å°äºæéï¼é£ä¹çæçä¸ä¸ä¸ªæ°åå°åå«æ¯ minvalue æ maxvalueã
NO CYCLE
å¦æ声æäºå¯éé®å NO CYCLEï¼ä»»ä½å¨åºåè¾¾å°å¶æ大æéå对 nextval çè°ç¨é½å°è¿åé误ã å¦ææ¢æªå£°æ CYCLE ä¹æªå£°æ NO CYCLEï¼ é£ä¹å°æ²¿ç¨åæç循ç¯è¡ä¸ºã
EXAMPLES ä¾å
ä» 105 å¼å§éæ°å¼å§ä¸ä¸ªå« serial çåºåï¼
ALTER SEQUENCE serial RESTART WITH 105;
NOTES 注æ
为äºé¿å并åçäºå¡ä»åä¸ä¸ªåºåè·åæ°å¼çæ¶å被é»å¡ä½ï¼ALTER SEQUENCE æä½ä»æ¥ä¸ä¼åæ»ï¼ ä¿®æ¹é©¬ä¸çæ并ä¸ä¸è½æ¢å¤ã
ALTER SEQUENCE å°ä¸ä¼ç«å³å½±åå端ç nextval ç»æï¼é¤äºå½åçä¹å¤ï¼ å为å®åå·²ç»ç¼å²äºçåºåå·ãå®ä»¬åªæå使ç¨åææå·²ç»ç¼å²çæ°å¼ä¹åæè½æè¯å°æ¹åäºçåºååæ°ãå½åå端å°ç«å³è¢«å½±åã
COMPATIBILITY å¼å®¹æ§
SQL99
ALTER SEQUENCE æ¯ PostgreSQL è¯è¨æ©å±ãå¨ SQL99 é没æ ALTER SEQUENCE è¯å¥ã
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh