What happens to index once the table got dropped?

by

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

Related Contents:

  1. How does database indexing work? [closed]
  2. SQL join: selecting the last records in a one-to-many relationship
  3. Oracle: If Table Exists
  4. List columns with indexes in PostgreSQL
  5. Can I add a UNIQUE constraint to a PostgreSQL table, after it’s already created?
  6. Postgres unique constraint vs index
  7. Creating an index on a table variable
  8. How important is the order of columns in indexes?
  9. Does Foreign Key improve query performance?
  10. How do I force Postgres to use a particular index?
  11. SQL Server indexes – ascending or descending, what difference does it make?
  12. Two single-column indexes vs one two-column index in MySQL?
  13. PostgreSQL LIKE query performance variations
  14. Does PostgreSQL support “accent insensitive” collations?
  15. Do I need to create indexes on foreign keys on Oracle?
  16. How to use index in select statement?
  17. sql primary key and index
  18. Is it better to create an index before filling a table with data, or after the data is in place?
  19. How to create a unique index on a NULL column?
  20. Index for finding an element in a JSON array
  21. Clustered vs Non-Clustered
  22. Copy a table (including indexes) in postgres
  23. How do I rename an Index in MySQL
  24. How to drop all NOT NULL constraints from a PostgreSQL table in one go
  25. mysql too many indexes?
  26. Rebuild all indexes in a Database
  27. How do composite indexes work?
  28. Indexing boolean fields
  29. Optimize GROUP BY query to retrieve latest row per user
  30. Query to check index on a table
  31. Get Table and Index storage size in sql server
  32. What’s the difference between a Table Scan and a Clustered Index Scan?
  33. PostgreSQL: Create an index to quickly distinguish NULL from non-NULL values
  34. What are Covering Indexes and Covered Queries in SQL Server?
  35. Order varchar string as numeric
  36. PostgreSQL Index on JSON
  37. What is a Covered Index?
  38. What is the difference between OFFLINE and ONLINE index rebuild in SQL Server?
  39. How do I index a database column
  40. Do indexes work with “IN” clause
  41. SQL primary key: integer vs varchar
  42. What is the purpose of PAD_INDEX in this SQL Server constraint?
  43. How can I force a query to not use a index on a given table?
  44. When should I use primary key or index?
  45. Indexes and multi column primary keys
  46. VARCHAR as foreign key/primary key in database good or bad?
  47. Is there any point using MySQL “LIMIT 1” when querying on indexed/unique field?
  48. Index for multiple columns in ActiveRecord
  49. Force index use in Oracle
  50. Why can’t I simply add an index that includes all columns?

Leave a Comment