▣ MEMBER 테이블 구조 변경 > ORACLE

• 목록

CREATE TABLE member (

id VARCHAR2(20),

PASS VARCHAR2(20),

NAME VARCHAR2(10), -- NVARCHAR2(10) --

GENDER VARCHAR2(6), -- NCHAR(1) F:여성 , M:남성 --

AGE NUMBER, -- 삭제 --

BIRTHDAY VARCHAR2(10),

PHONE VARCHAR2(13),

SIGNDATE DATE

-- EMAIL VARCHAR2(100) 추가 -- 

);

[아래 구문 실행]

ALTER TABLE MEMBER MODIFY NAME NVARCHAR2(10);

alter table member modify gender nchar(1); //명령문 대.소문자 상관없음 

ALTER TABLE MEMBER DROP COLUMN AGE;

ALTER TABLE MEMBER ADD EMAIL VARCHAR2(100);

[수정된 쿼리]

CREATE TABLE member (

id VARCHAR2(20),

PASS VARCHAR2(20),

NAME NVARCHAR2(10),

GENDER NCHAR(1),

BIRTHDAY VARCHAR2(10),

PHONE VARCHAR2(13),

SIGNDATE DATE,

EMAIL VARCHAR2(100)

);