RENAME COLUMN æ–‡ã?§è¡¨ã?«ã?‚る列ã?®å??å‰?を変更ã?§ã??ã?¾ã?™ã€‚
RENAME COLUMNæ–‡ã?«ã‚ˆã‚Šå…¨ã?¦ã?®ã‚¹ã‚ーマã?«ã?‚ã‚‹æ—¢å˜è¡¨ã?®æ—¢å˜åˆ—ã?®å??å‰?を変更ã?§ã??ã?¾ã?™ã€‚(SYSã?®ã‚¹ã‚ーマを除ã??ã?¾ã?™ã€‚)
列ã?®å??å‰?を変ã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã‚‹ã?®ã?¯ã€?データベースã?®æ‰€æœ‰è€…ã?‚ã‚‹ã?„ã?¯è¡¨ã?®æ‰€æœ‰è€…ã?®ã?¿ã?§ã?™ã€‚
表ã?¸ã?®ä»–ã?®å®šç¾©å¤‰æ›´ã?¯å?¯èƒ½ã?§ã?™ã€‚詳細ã?¯ã€?ALTER TABLE 文をå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
RENAME COLUMN 表å??.å?˜ç´”列å?? TO å?˜ç´”列å??
RENAME COLUMN EMPLOYEE.MANAGER TO SUPERVISOR
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