sql server
-- 修改字段名
sp_rename 'tableName.columnName','new_columnName','column';
EXEC sp_rename 'tableName.columnName','new_columnName','column';
alter table cost drop column file_dir;
alter table cost add file_dir nvarchar(500);
alter table tablename alter column columnname nvarchar(64);
-- 修改表名
sp_rename 'cost', 'cost1';
EXEC sp_rename 'cost', 'cost1';
mysql
-- 修改字段名
alter table cost drop column file_dir;
alter table cost add file_dir nvarchar(500);
alter table cost change file_dir file_dir_new nvarchar(50);
-- 修改表名
rename table cost to cost1;
alter table cost rename to/as cost1;