# -*- coding: utf-8 -*- 
import pymssql


conn = pymssql.connect(server='db02.be4energy.com', user='be4visionadmin', password='cdg4s!fcv')
cur = conn.cursor()

cur.execute('use cdb;')

cur.execute("ALTER TABLE CDB_COLUMN_TYPES ALTER COLUMN Translation_Key nvarchar(100)")

cur.execute('use COMMONDB;')

cur.execute("ALTER TABLE value_type ALTER COLUMN unit nvarchar(50)")
cur.execute("ALTER TABLE value_type ALTER COLUMN vpc nvarchar(100)")

conn.commit()
conn.close()