RENAME COLUMN æ–‡

RENAME COLUMN æ–‡ã?§è¡¨ã?«ã?‚る列ã?®å??å‰?を変更ã?§ã??ã?¾ã?™ã€‚

RENAME COLUMNæ–‡ã?«ã‚ˆã‚Šå…¨ã?¦ã?®ã‚¹ã‚­ãƒ¼ãƒžã?«ã?‚る既存表ã?®æ—¢å­˜åˆ—ã?®å??å‰?を変更ã?§ã??ã?¾ã?™ã€‚(SYSã?®ã‚¹ã‚­ãƒ¼ãƒžã‚’除ã??ã?¾ã?™ã€‚)

列ã?®å??å‰?を変ã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã‚‹ã?®ã?¯ã€?データベースã?®æ‰€æœ‰è€…ã?‚ã‚‹ã?„ã?¯è¡¨ã?®æ‰€æœ‰è€…ã?®ã?¿ã?§ã?™ã€‚

表ã?¸ã?®ä»–ã?®å®šç¾©å¤‰æ›´ã?¯å?¯èƒ½ã?§ã?™ã€‚詳細ã?¯ã€?ALTER TABLE 文をå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。

æ§‹æ–‡

RENAME COLUMN 表å??.å?˜ç´”列å?? TO å?˜ç´”列å??

例

employeeã?¨ã?„ã?†è¡¨ã?«ã?‚ã‚‹managerã?¨ã?„ã?†åˆ—ã?®å??å‰?ã‚’ supervisorã?«å¤‰æ›´ã?™ã‚‹ã?«ã?¯æ¬¡ã?®ã‚ˆã?†ã?«ã?—ã?¾ã?™ã€‚
RENAME COLUMN EMPLOYEE.MANAGER TO SUPERVISOR
ALTER TABLEã?¨RENAME COLUMNを使ã?£ã?¦ã€?列ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã‚’変更ã?§ã??ã?¾ã?™ã€‚ tã?¨ã?„ã?†è¡¨ã?«ã?‚ã‚‹c1ã?¨ã?„ã?†åˆ—ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã‚’NEWTYPEã?«å¤‰æ›´ã?™ã‚‹ã?Ÿã‚?ã?«ã?¯ã€?次ã?®ã‚ˆã?†ã?«ã?—ã?¾ã?™ã€‚

    ALTER TABLE t ADD COLUMN c1_newtype NEWTYPE
    UPDATE t SET c1_newtype = c1
    ALTER TABLE t DROP COLUMN c1
    RENAME COLUMN t.c1_newtype TO c1

利用上�留�点

Note: 列をå?‚ç…§ã?™ã‚‹ãƒ“ューやトリガã€?ãƒ?ェック制約ã€?外部キー制約ã?Œã?‚ã‚‹å ´å?ˆã€?列å??ã?®å¤‰æ›´ã?¯å¤±æ•—ã?—ã?¾ã?™ã€‚
Note: å??称を変更ã?™ã‚‹åˆ—ã‚’å?‚ç…§ã?™ã‚‹ã€?é–‹ã?„ã?Ÿã‚«ãƒ¼ã‚½ãƒ«ã?Œã?‚ã‚‹å ´å?ˆã€?RENAME COLUMNæ–‡ã?¯å®Ÿè¡Œã?§ã??ã?¾ã?›ã‚“。
Note: 列ã?¸ã?®ç´¢å¼•ã?Œã?‚ã?£ã?¦ã‚‚ã€?列ã?®å??å‰?ã?¯å¤‰æ›´ã?§ã??ã?¾ã?™ã€‚索引ã?¯æ›´æ–°ã?•れã?¦ã€?変更後ã?®åˆ—å??ã?§å?‚ç…§ã?™ã‚‹ã‚ˆã?†ã?«ã?ªã‚Šã?¾ã?™ã€‚
Related reference
RENAME INDEX æ–‡
RENAME TABLE æ–‡