Home » Bigquery » Tutorials » Drop external table

BigQuery Drop external table

Deletes only the external table definition. The data in the external location is not affected.

Drop external table example

DROP EXTERNAL TABLE IF EXISTS mydataset.external_table

Syntax reference

DROP EXTERNAL TABLE [IF EXISTS] table_name