If you click Show Related for a target table object, the Show Related notebook displays any steps or warehouse schemas with first-level dependencies on that target file. You can view second-level dependencies by clicking Show Related for each object with a first-level dependency.
Steps Populated
When you drop a target table, steps that are populated by that target table might produce unexpected results.
Steps Used as Source
When you drop a target table, steps that the target table uses as sources might produce unexpected results.
Warehouse schemas
When you drop a target table, relationships based on that target table in the warehouse schema are broken.