SQL常用命令

1.修改表:

添加/删除/修改列

ALTER TABLE table_name ADD column_name column_type

ALTER TABLE table_name DROP column_name

ALTER TABLE table_name modify column_name column_type

informix 修改列名

RENAME COLUMN table_name.column_name TO new_column_name