[专题] 批量修改数据库表结构 --专题

-------------- 202007035

批量修改数据库表结构  --专题

 

https://blog.csdn.net/weixin_30484247/article/details/98991946  批量修改数据库表的架构sql (sql 2005)

 

---mysql
https://blog.csdn.net/weixin_30627341/article/details/98931502  在线批量修改mysql中表结构 (mysql)
https://www.cnblogs.com/xzlive/p/10773387.html (mysql)
https://blog.csdn.net/BtWangZhi/article/details/83385382 MySQL--存储过程批量修改表结构

 

https://blog.csdn.net/changnan85/article/details/13016893 批量修改mysql表结构信息
{
use information_schema;

 

select 
CONCAT('ALTER TABLE `'
,table_schema,'`.`'
,table_name,'`'
,' CHANGE COLUMN '
,'`',column_name,'` `' -- source col name
,column_name,'` '         -- change col name
,' INT(10) ' -- type
,if(is_nullable='no',' NOT NULL ','')
,' ',EXTRA
,' COMMENT \'',COLUMN_COMMENT,'\';'
)
from columns  where table_schema = 'isuzu1008'
and column_type = 'int(11)' and column_name like '%id%';
————————————————
版权声明：本文为CSDN博主「changnan85」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/changnan85/java/article/details/13016893

 

}

 

https://blog.csdn.net/iteye_5736/article/details/81620852 批量修改数据结构

 

https://blog.csdn.net/hyb3280660/article/details/80651378?utm_medium=distribute.pc_relevant.none-task-blog-OPENSEARCH-13.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-OPENSEARCH-13.nonecase  sqlserver批量更改表架构
https://www.jianshu.com/p/9ad3657b46c3 批量修改数据库表引擎类型 (mysql)

 

----postgres 
批量生成多个库中的表，删除表等 (用存储过程写循环) create table,delete table  (除用存储过程还可以写程序来批量修改表结构alert table)
https://blog.csdn.net/weixin_30477293/article/details/97781857?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-11.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-11.nonecase

 

批量修改表名称 ,查询多个库中的多个表的名称
https://blog.csdn.net/king_le0/article/details/47837999?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase

 

https://blog.csdn.net/qq_33158376/article/details/86609797  PostgreSQL批量修改函数拥有者
https://blog.csdn.net/washli2001/article/details/9351743 批量修改PostgreSQL数据表的名称