Join and Hash Indexes and DROP USER - Advanced SQL Engine - Teradata Database

If a user contains a table referenced by a join or hash index contained in a different database or user, then you cannot drop the user that contains the referenced table unless you first drop the referencing hash or join index.