表格操作

建立表格

語法：

    CREATE [TEMPORARY] TABLE table_name
    
    ( column_definition [, {next_column_definition}...] )
    
    [IN tablespace_name]
    
    [CHECK table_constraint]
    
    [LOCK MODE {PAGE|TABLE|ROW}]
    
    [FILLFACTOR fill_value] [NOCACHE]
        

範例：

    CREATE TABLE S (
    
    2>S# CHAR(5) NOT NULL,
    
    3> SNAME CHAR(20),
    
    4> STATUS INTEGER,
    
    5> CITY CHAR(15) );
        

刪除表格

語法：

    DROP TABLE tablename
        

新增欄位

語法：

    ALTER TABLE table_name ADD column_definition 
    
    [give_opt] [column_sequence]
    
    give_opt = GIVE {literal | NULL | builtin-function |SEQUENTIAL}
    
    column_sequence = {BEFORE column-name | AFTER column-name}
        

更改表格結構

語法：

    ALTER TABLE table_name MODIFY modify_column_definition
    
    modify_column_definition = 
    
    { column-name NAME TO new-column-name
    
    | column-name TYPE TO data-type
    
    | column-name NULL TO NOT NULL give-opt
    
    | column-name DEFAULT TO default-val
    
    | column-name CONSTRAINT TO CHECK expression
    
    | column-name column-sequence 
    
    | column-name DROP DEFAULT
    
    | column-name DROP CONSTRAINT
    
    |column-name TO column-definition [give-opt][column-sequence]}
        

範例：

    ALTER TABLE employee MODIFY name TYPE TO CHAR(10);