15.00 - DROP FUNCTION and Algorithmic Compression - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.