def get_show_columns(database):
    """
    Gets the query of SHOW COLUMNS for a given database.

    :type str
    :param database: A database name
    :rtype str
    :return A query
    """

    return ("SELECT `TABLE_NAME`, `COLUMN_NAME` "
            " FROM "
            "`information_schema`.`COLUMNS`"
            " WHERE "
            "`TABLE_SCHEMA` = '{:s}'").format(database)