The DROP MODEL statement

Overview

To delete a model in BigQuery ML, use the DROP MODEL or the DROP MODEL IF EXISTS DDL statement.

The DROP MODEL DDL statement deletes a model in the specified dataset. If the model name does not exist in the dataset, the following error is returned:

Error: Not found: Model myproject:mydataset.mymodel

The DROP MODEL IF EXISTS DDL statement deletes a model in the specified dataset only if the model exists. If the model name does not exist in the dataset, 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 information about the supported model types of each SQL statement and function, and all of the supported SQL statements and functions for each model type, read the End-to-end user journey for each model.

Syntax

{DROP MODEL | DROP MODEL IF EXISTS}
model_name

Where:

{DROP MODEL | DROP MODEL IF EXISTS} is one of the following statements:

  • DROP MODEL — deletes a model in the specified dataset
  • DROP MODEL IF EXISTS — deletes a model only if the model exists in the specified dataset

model_name is the name of the model you're deleting.