SQL 對字段的增删改

 增加字段

alter table docdsp  add dspcode char(200)

删除字段

ALTER TABLE table_NAME DROP COLUMN column_NAME

字段修改                                                                                                                                                                                   ALTER TABLE table_name  ALTER COLUMN column_name new_data_type