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