SqlServer、Mysql、およびOracleの変更削除フィールドの追加


SqlServer(Transact-SQL):
    :
ALTER 
TABLE    ADD         
    :
ALTER TABLE    ADD   1     1,  2     2
        :
ALTER TABLE    ALTER COLUMN        
          :      
    :
ALTER TABLE    DROP COLUMN   
    :
ALTER TABLE    DROP COLUMN   1,  2

         :
   ,          .
 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MySql:

    :
ALTER TABLE    ADD        
    :
ALTER TABLE    ADD   1     1,Add   2     2
        :
ALTER TABLE    CHANGE COLUMN        
          :
ALTER TABLE    CHANGE COLUMN        ,CHANGE COLUMN        
    :
ALTER TABLE    DROP COLUMN   
    :
ALTER TABLE    DROP COLUMN   1,DROP COLUMN   2
         :
ALTER TABLE    ADD   1     1,CHANGE COLUMN        ,DROP COLUMN 
  1

(COLUMN        )
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
Oracle(PL/SQL):
    :
ALTER TABLE    ADD        
    :
ALTER TABLE    ADD (   1     1,  2     2)
 
        :
ALTER TABLE    MODIFY        
          :
ALTER TABLE    MODIFY (   1     1,  2     2)
    :
ALTER TABLE    DROP COLUMN   
    :
ALTER TABLE    DROP (  1,  2)


         :
ALTER TABLE    ADD (   1     1,  2     2) MODIFY (   3     3,  4 
    4)