SqlServer、Mysql、およびOracleの変更削除フィールドの追加
1714 ワード
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)