Select 'EXEC sp_rename 
    @objname = ''' + TABLE_NAME + '.' + COLUMN_NAME + ''', 
    @newname = ''' + LOWER( COLUMN_NAME ) + ''', 
    @objtype = ''COLUMN''' 
FROM INFORMATION_SCHEMA.COLUMNS