DROP MODEL

Removes an AI model from the registry. The provider endpoint, the connection, and the vault credential are untouched.

Category: ai-modelPrivilege: catalog:write on the control plane.DeltaForge extension

Syntax

DROP MODEL [IF EXISTS] <name>

Description

## Overview DROP MODEL deletes the registry row. It deliberately cascades nothing: the REST connection and its vault credential may back other models or API endpoints, so they are left in place. Queries that reference the dropped model through AI_GENERATE / AI_GENERATE_EMBEDDINGS fail at their next model resolution with a clear 'not found' error naming SHOW MODELS.

Parameters

Name	Type	Description
`name`		The registry name of the model to drop, matched case-insensitively.
`IF EXISTS`		Turns a missing model into a no-op success instead of an error.

Examples

DROP MODEL gpt5;

-- Idempotent cleanup
DROP MODEL IF EXISTS gpt5;

Pitfalls

Requires a control-plane connection (catalog router).
Sessions cache a resolved model for up to five minutes, so an in-flight session can keep invoking a just-dropped model until its cache entry expires; new resolutions fail immediately.