What happens to index once the table got dropped?
In Oracle when dropping a table
- all table indexes and domain indexes are dropped
- any triggers defined on the table are dropped
- if table is partitioned, any corresponding local index partitions are dropped
- if the table is a base table for a view or if it is referenced in a stored procedure, function, or package, then these dependent objects are invalidated but not dropped
In Postgres
DROP TABLE always removes -
1. any indexes
2. rules
3. triggers
4. constraints
that exist for the target table.