To find the dependencies of an index or a constraint, you can use the system catalog views or the dynamic management views in SQL Server, or the data dictionary views or the DBMS_UTILITY package ...