GaramX

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 SALED ADD REG_KIND varchar2(10);

COMMENT ON TABLE 테이블명 IS '설명';
 
comment ON COLUMN 테이블명.필드명 IS '설명';