What happens to index once the table got dropped?

Question

After dropping the table, found that the index created on the columns of the dropped table is gone. I just want to know what happens after that. Could someone please explain?

What all are the others getting dropped along with table drop?

Answer 1

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

Answer 2

In Postgres

DROP TABLE always removes - 1. any indexes 2. rules 3. triggers 4. constraints that exist for the target table.