Alpha

These pages are built from main, turborel 0.0.0. Anything may change from one build to the next: SQL, API, protocol and files alike.

DROP TRANSFORM

Statements

NAME

DROP TRANSFORM: drop transform groups of a user-defined type

SYNOPSIS

<drop transform statement> ::=
    DROP { TRANSFORM | TRANSFORMS } { ALL | <group name> } FOR <user-defined type name> <drop behavior>

<drop behavior> ::= CASCADE | RESTRICT

DESCRIPTION

DROP TRANSFORM drops a type's group of the name, or every group of the type with ALL, and leaves their functions. No routine of turborel uses a transform, so CASCADE and RESTRICT drop alike.

DROP TRANSFORM runs within the session's transaction: ROLLBACK undoes it.

RULES

  1. The type exists, its user owns it, and it has a group of the name, or with ALL, any group.

PRIVILEGES

The owner of the type.

ERRORS

SQLSTATE SQLCODE When
2A000 -103 A rule above is broken
2A000 -104 Its user does not own the type

EXAMPLES

CREATE TYPE TEMP AS (DEGREES INTEGER) FINAL;
CREATE FUNCTION TEMP_OUT (T TEMP) RETURNS INTEGER DETERMINISTIC CONTAINS SQL RETURN T.DEGREES;
CREATE TRANSFORM FOR TEMP HOST (FROM SQL WITH FUNCTION TEMP_OUT (TEMP)) CLIENT (FROM SQL WITH FUNCTION TEMP_OUT (TEMP));
DROP TRANSFORM HOST FOR TEMP RESTRICT;
SELECT GROUP_NAME FROM INFORMATION_SCHEMA.TRANSFORMS;
DROP TRANSFORM ALL FOR TEMP RESTRICT;
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TRANSFORMS;
OK
OK
OK
OK
 GROUP_NAME
--------------------------------------------------------------
 CLIENT
(1 row)
OK

----------------------
                    0
(1 row)
DROP TRANSFORM HOST FOR TEMP RESTRICT;
turborel: SQLCODE -103 (SQLSTATE 2A000): type ANN.TEMP has no transform group HOST [ISO/IEC 9075-2:2023 §11.71 SR2] (at character 24)

STANDARD

ISO/IEC 9075-2:2023 §11.71, Feature S241. See CONFORMANCE.md.

SEE ALSO

CREATE TRANSFORM, ALTER TRANSFORM