批量更改sql表头

1，首先你的把所有表明提取出来
组合sql语句就行

import pymssql
import os
import pandas as pd
import random

#conn = pymssql.connect(host='ip', user='', password='', database='数据库名，不是表明’,
                       #charset='utf8')#没有端口号。链接不上
conn = pymysql.connect(host='localhost', user='root', password='123456', db='update_new', port=3306, charset="utf8",
                       use_unicode=True)
#这块是链接数据库的
  cursor = conn.cursor()
    #sql=f"alter table {weet} alter column EndDt datetime"
    #sql=f"select name,(select name from systypes where xusertype=syscolumns.xusertype) from syscolumns where id=object_id('{weet}')"
    sql=f"select   name   from   syscolumns   where   id=object_id('{weet}')"#weet指表明，加点
    cursor.execute(sql)
    result = cursor.fetchall()
    for a in result:
        #print(a[0])
        lis=a[0]

		        zoop=lis.replace('1','e').replace('2','x').replace('3','w').replace('4','u').replace('5','j').replace('6','r').replace('7','c').replace('8','k').replace('9','v').replace('0','xu')
		        sql = f"EXEC sp_rename '{weet}.[{lis}]', '{zoop}' , 'COLUMN';"
       print(sql)
        cursor.execute(sql)
        conn.commit()
    cursor.close()