기본 DDL

Table

    ㅇ 신규

        - CREATE TABLE TableName (
               Col01 char(8)     NOT NULL,
               Col02 varchar(20) NOT NULL,
                ...
           )

    ㅇ 삭제

        - DROP TABLE TableName

Column

    ㅇ 신규

        - ALTER TABLE TableName

          ADD Column_name Data_type(Length) DEFAULT DefaultValue NullOption

          예) Alter Table TmpTable

               ADD TmpCol Varchar(30) DEFAULT '20' NOT NULL

      
ALTER TABLE quiz_sheet
       add column REG_TIME timestamp 
       

 

삭제

ALTER TABLE quiz_try
       drop column try_start_time
       

 

Primary Key(???)

    ㅇ 신규

        - ALTER TABLE TableName

          ADD PRIMARY KEY (Col01, Col02...)