ODBC guide

List tables

Returns tables for the given project/dataset. If ProjectId or DatasetId is omitted, connection-level settings are used.

SELECT * FROM list_tables
--WITH(ProjectId='MyProjectId')
--WITH(ProjectId='MyProjectId',DatasetId='MyDatasetId')