Skip to main content

​
DROP TYPE

Turso Extension: DROP TYPE is a Turso-specific statement not available in standard SQLite. This feature is experimental and must be enabled before use.
The DROP TYPE statement removes a user-defined custom type from the database. Once dropped, the type name can no longer be used in new column definitions.

​
Syntax

DROP TYPE [IF EXISTS] type-name;

​
Description

DROP TYPE removes the named custom type from the database. The type must exist unless the IF EXISTS clause is specified.

​
Clauses

ClauseDescription
IF EXISTSSuppresses the error that would occur if the type does not exist. The statement is a no-op when the type is not found.
type-nameThe name of the custom type to remove.

​
Restrictions

A type cannot be dropped while any table column uses it. All columns of that type must be removed or the table must be dropped before the type can be dropped. 
CREATE TYPE cents BASE integer ENCODE value * 100 DECODE value / 100;

CREATE TABLE prices (
    id INTEGER PRIMARY KEY,
    amount cents
) STRICT;

-- This fails because the 'prices' table has a column of type 'cents'
DROP TYPE cents;
-- Error: type 'cents' is in use

-- Drop the table first, then the type
DROP TABLE prices;
DROP TYPE cents;

​
Examples

​
Drop a Custom Type

CREATE TYPE reversed_text BASE text
    ENCODE turso_reverse(value)
    DECODE turso_reverse(value);

DROP TYPE reversed_text;

​
Drop a Type with IF EXISTS

-- Safe to run even if the type does not exist
DROP TYPE IF EXISTS reversed_text;

​
See Also