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?

No point having an index with nothing to point at :) Your indices get dropped with the table. — StuartLC, Dec 08 '11 at 15:04

score 53 · Accepted Answer · answered Dec 08 '11 at 15:09

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

score 16 · Answer 2 · answered Jan 04 '19 at 06:10

16

In Postgres

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

answered Jan 04 '19 at 06:10

Atty

691
13
20

Yeeee, rock! Postgres post is the only one with BOLD title – chill appreciator Oct 27 '20 at 10:17

score 11 · Answer 3 · edited May 23 '17 at 10:31

11

MySQL also drops table indexes when tables are dropped.

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

edited May 23 '17 at 10:31

Community

1
1

answered Jul 14 '16 at 10:22

Magnus H

111
1
5

score 11 · Answer 4 · answered Apr 23 '18 at 15:57

11

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

answered Apr 23 '18 at 15:57

Merijn Vogel

196
2
7

What happens to index once the table got dropped?

4 Answers4