Delete a search index
When you no longer need a search index or want to change which columns are
indexed on a table, you can delete the index currently on that table. To do
this, use the
DROP SEARCH INDEX
If an indexed table is deleted, its index is deleted automatically.
DROP SEARCH INDEX my_index ON dataset.simple_table;
- For a high-level overview, see the Introduction to search in BigQuery.
- For information about efficient searching of indexed columns, see Search.