When a table is dropped, the corresponding indexes are automatically dropped. For each DML operation performed, the corresponding indexes are automatically updated. A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
