Using mySQL, we can run a query that gets us the alter statement, the tablename and the column name

```sql
SELECT CONCAT(
 'ALTER TABLE ', table_name,
 ' CHANGE ', column_name, ' ',
 LOWER(column_name), ' ', column_type, ' ', extra,
 CASE WHEN IS_NULLABLE = 'YES' THEN  ' NULL' ELSE ' NOT NULL' END, ';') AS line, table_name, column_name
FROM information_schema.columns
 WHERE table_schema = 'uaa'
ORDER BY line;
```