# List metadata from selected tables with WHERE clause #standardSQL SELECT table_name, creation_time FROM `bigquery-public-data.ethereum_blockchain`.INFORMATION_SCHEMA.TABLES WHERE table_type = "BASE TABLE" AND table_name LIKE "%token%";
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter