[SQL] ALTER TABLE

1. COLUMN 추가

 

- ALTER TABLE table_name ADD column_name datatype

ex) ALTER TABLE Product ADD Name VARCHAR(50)

 

 

 

2. COLUMN 삭제

 

- ALTER TABLE table_name DROP COLUMN column_name

ex) ALTER TABLE Product DROP COLUMN Name

 

 

 

3. COLUMN TYPE 변경

 

1) MS SQL

- ALTER TABLE table_name ALTER COLUMN column_name datatype

ex) ALTER TABLE Product ALTER COLUMN Name VARCHAR(30)

 

2) MYSQL / ORACLE

- ALTER TABLE table_name MODIFY COLUMN column_name datatype

ex) ALTER TABLE Product MODIFY COLUMN Name VARCHAR(30)