DROP BLOOMFILTER INDEX ON [TABLE] table_name [FOR COLUMNS(columnName1, columnName2, ...)]
Drop a Bloom filter index.
The command fails if either the table name or one of the columns does not exist. All Bloom filter related metadata is removed from the specified columns.
When a table does not have any Bloom filters, the underlying index files are cleaned when the table is vacuumed.