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

posted @ 2011-08-02 09:10  zjking99  阅读(142)  评论(0编辑  收藏  举报