How to generate CREATE TABLE script from an existing table

Question

I create a table with Big Query interface. A large table. And I would like to export the schema of this table in Standard SQL (or Legacy SQL) syntax.

Is it possible ?

Thanks !

Answer 1

You can get the DDL for a table with this query:

SELECT t.ddl
FROM `your_project.dataset.INFORMATION_SCHEMA.TABLES` t
WHERE t.table_name = 'your_table_name'
;