Redenumire coloane lowercase
SELECT CONCAT('ALTER TABLE ', TABLE_NAME, ' CHANGE `', COLUMN_NAME, '` `',
LOWER(COLUMN_NAME), '` ', COLUMN_TYPE, ';')
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '_Nume BD_'
Redenumire tabele lowercase
SELECT CONCAT('RENAME TABLE ', TABLE_NAME, ' TO `', LOWER(TABLE_NAME),';')
FROM INFORMATION_SCHEMA.tables WHERE TABLE_SCHEMA = '_Nume BD_'

Comenzile de mai sus vor returna o serie de comenzi care trebuiesc apoi executate in MySQL pentru redenumirea finala.