Database/SQL
[SQL] ALTER RENAME
혀나Lee
2016. 12. 14. 09:39
테이블 명
ALTER TABLE <table_name> RENAME TO <new_table_name>;
테이블 컬럼 명
ALTER TABLE <table_name> RENAME COLUMN <column_name> TO <new_column_name>;
Constraint 명 (Primary Key, Foreign Key, ..)
ALTER TABLE <table_name> RENAME CONSTRAINT <constraint_name> TO <new_constraint_name>;
Index 명
ALTER INDEX <index_name> RENAME TO <new_index_name>;