===== Create Table ===== CREATE TABLE "ASLIB"."SALED_HIST" ( "ID" NUMBER(18,0) GENERATED BY DEFAULT AS IDENTITY, DEL_USER_ID varchar2(30 byte), DEL_DATE varchar2(8 byte), DID NUMBER(18), "CSTMR_ID" VARCHAR2(5 BYTE), "ITEM_ID" VARCHAR2(9 BYTE), "COLOR_ID" VARCHAR2(4 BYTE), "MGN_RATE" NUMBER(5,2), "MGR_RATE" NUMBER(5,2), "HAL_RATE" NUMBER(5,2), "PAN_PRICE" NUMBER(7,0), "SALEH_ID" NUMBER(18,0), "ADD_DATE" VARCHAR2(8 BYTE), "USER_ID" VARCHAR2(30 BYTE), CONSTRAINT "SALED_HIST_PK" PRIMARY KEY ("ID") using index TABLESPACE "TS_ASL_IDX" ) TABLESPACE "TS_ASL_DAT" ; ===== Alter Table ===== alter table SALED add REG_KIND varchar2(10); ===== Comment ===== COMMENT ON TABLE 테이블명 IS '설명'; comment ON COLUMN 테이블명.필드명 IS '설명';