If you click Show Related for a source table object, the Show Related notebook displays any steps with first-level dependencies on that source table. You can view second-level dependencies by clicking Show Related for each object with a first-level dependency.
Steps Populated
When you drop a source table, steps that are populated by that source table might produce unexpected results.