The DROP MODEL statement
To delete a model in BigQuery ML, use theDROP MODEL or theDROPMODEL IF EXISTS DDL statement.
TheDROP MODEL DDL statement deletes a model in the specified dataset. Ifthe model name does not exist in the dataset, the following error is returned:
Error: Not found: Model myproject:mydataset.mymodel
TheDROP MODEL IF EXISTS DDL statement deletes a model in the specifieddataset only if the model exists. If the model name does not exist in thedataset, no error is returned, and no action is taken.
If you are deleting a model in another project, you must specify the project,dataset, and model in the following format: `[PROJECT].[DATASET].[MODEL]`(including the backticks); for example, `myproject.mydataset.mymodel`.
For more information about supported SQL statements and functions for differentmodel types, see the following documents:
- End-to-end user journeys for generative AI models
- End-to-end user journeys for time series forecasting models
- End-to-end user journeys for ML models
- End-to-end user journeys for imported models
Syntax
{DROP MODEL | DROP MODEL IF EXISTS}model_nameWhere:
{DROP MODEL | DROP MODEL IF EXISTS} is one of the following statements:
DROP MODEL— deletes a model in the specified datasetDROP MODEL IF EXISTS— deletes a model only if the model exists in thespecified dataset
model_name is the name of the model you're deleting.
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-11-24 UTC.