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>;