create table member(
mem_id varchar(20) not null primary key,
passwd varchar(20) not null,
name varchar(20) not null
)
alter table member add reg_date date not null after name;
=> name 필드 뒤에 reg_date 추가
alter table member add reg_date date not null after mem_id;
=> mem_id 필드 뒤에 reg_date 추가
alter table member drop reg_date;
=> reg_date 필드 삭제
desc member;
Trackback Address :: http://www.ssial.com/trackback/57
