15.00 - DROP FUNCTION and Algorithmic Compression - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
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.