SQL SERVER:
更改列的数据类型:
ALTER TABLE table_name ALTER COLUMN column_name new_data_type[(precision[,scale])]
更改列名:
sp_rename table_name.old_column_name , new_column_name
ORACLE:
更改列的数据类型:
alter table table_name modify column_name new_data_type
更改列名:
alter table table_name rename old_column_name To new_column_name
DB2:
更改列的数据类型:
alter table table_name alter column_name SET DATA TYPE new_data_taye
更改列名:
....