CODEWITHSUNDEEP
sqlindexingsql-drop
Vaandu
Vaandu

Reputation: 4935

What happens to index once the table got dropped?

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?

Upvotes: 44

Views: 45373

Answers (4)

Atty
Atty

Reputation: 801

In Postgres 

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

Upvotes: 18

Merijn Vogel
Merijn Vogel

Reputation: 306

By default, MS Sql Server also drops indexes when a table is dropped. (Observed in version 13.0.4206.0.)

Upvotes: 12

Magnus H
Magnus H

Reputation: 111

MySQL also drops table indexes when tables are dropped.

For more info, see Does dropping a table in MySQL also drop the indexes?

Upvotes: 11

Raihan
Raihan

Reputation: 10395

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

Upvotes: 54

Related Questions