15.00 - DROP FUNCTION and Algorithmic Compression - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

DROP FUNCTION and Algorithmic Compression

You can only drop a function that algorithmically compresses or decompresses data if there are no existing references to that UDF by any column across all databases and users. This rule exists because when a column is already compressed using a certain algorithm and its decompression function is dropped, Teradata Database cannot decompress the compressed data.