Returning a Table Name and its Most Recent Update in BigQuery

Question

I am looking to write a BigQuery query that returns three columns:

| school_name | table_name | last_update

Each table that I would run this for has many columns, but the important one I'd need is named school_name, so my thinking is that my query should look something like this:

SELECT school_name, table_name, last_update
FROM table_name;

However, I'm not sure how to actually access the table_name and last_update metadata. This is part of a larger project to return this information in ONE QUERY for multiple tables. I will either use UNION for this, or have to figure out a way to refer to multiple tables that follow certain naming conventions within our BQ workspace (since it is for tables whose names end with a certain word).