DROP SEQUENCE

Name

DROP SEQUENCE -- ½ÃÄö½º¸¦ »èÁ¦ÇÕ´Ï´Ù

Synopsis

DROP SEQUENCE [ IF EXISTS ] 
name
 [, ...] [ CASCADE | RESTRICT ]

¼³¸í

DROP SEQUENCE´Â ½ÃÄö½º ¹øÈ£ »ý¼º±â¸¦ »èÁ¦ÇÕ´Ï´Ù.

ÆÄ¶ó¹ÌÅÍ

IF EXISTS

½ÃÄö½º°¡ Á¸ÀçÇÏÁö ¾Ê´Â °æ¿ì, ¿¡·¯¸¦ ´øÁöÁö ¸¶¼¼¿ä. ÀÌ °æ¿ì, ÁÖÀÇ ¸Þ¼¼Áö°¡ ¹ßÇàµË´Ï´Ù.

name

½ÃÄö½ºÀÇ À̸§(¼±ÅÃÀûÀ¸·Î ÇÑÁ¤µÈ ½ºÅ°¸¶)ÀÔ´Ï´Ù.

CASCADE

½ÃÄö½º¿¡ ÀÇÁ¸Çϰí ÀÖ´Â °´Ã¼¸¦ ÀÚµ¿ÀûÀ¸·Î »èÁ¦ÇÕ´Ï´Ù.

RESTRICT

ÀÇÁ¸ÇÏ´Â °´Ã¼°¡ ÀÖ´Â °æ¿ì, ½ÃÄö½ºÀÇ »èÁ¦¸¦ °ÅºÎÇÕ´Ï´Ù. À̰ÍÀÌ µðÆúÆ®ÀÔ´Ï´Ù.

¿¹

½ÃÄö½ºserial¸¦ »èÁ¦ÇÕ´Ï´Ù.

DROP SEQUENCE serial;

ȣȯ¼º

DROP SEQUENCE´Â 1°³ÀÇ Ä¿¸àµå·Î 1°³ÀÇ ½ÃÄö½º¸¸À» »èÁ¦ÇÏ´Â °Í°ú PostgreSQLÀÇ È®ÀåÀÎ IF EXISTS¿É¼ÇÀ» Á¦¿ÜÇϰí´Â, SQLÇ¥ÁØ¿¡ »óÀÀÇÕ´Ï´Ù.

°ü·Ã Ç׸ñ

CREATE SEQUENCE , ALTER SEQUENCE