When calling drop_all_indexes_on_table, indexes on every table matching the target will be dropped. If a user has an identically named table on another schema, it will also drop those indexes.
schema_a.table
schema_b.table
calling drop_all_indexes_on_table on schema_a.table drops both schema_a.table and schema_b.table's indexes