How to get show create table in Big Query web UI

Question

I want to get Create table script for an existing Table basically DDL from web UI or something similar to Show create table . I have googled couldn't find anything relevant

Answer 1

Cool news! Launched today, now you can get the DDL from INFORMATION_SCHEMA.TABLES

Here is the example from Google Documentation:

SELECT
 table_name, ddl
FROM
 `bigquery-public-data`.census_bureau_usa.INFORMATION_SCHEMA.TABLES
WHERE
 table_name="population_by_zip_2010"