Developers often find the names that they have previously selected for an object will cause problems. Bad news is that most developers are aware of the names of the objects they have chosen. There are hundreds of views, stored procedures, and functions in the database - and these object names have already appeared many times.
You need to determine the task before the risk changes to the object name. When an object of interest is a table or view, you can use the Deprondencies tool in Enterprise Manager (Enterprise Manager). To use this tool, run the Enterprise Manager, expand the database node, expand the child node (table or view) you care, right click on the object you care, select All Tasks, then select Show Dependencies (Show Correlation). This will give two lists: Objects That Depend On X (object attached to X) and Objects That X Depends ON (× Items). The tool even provides a check box for selecting only the correlation between the first level or shows all levels of correlation. However, in fact, you can't do anything with these lists.
To get a more useful list (for example, you can copy and paste), you can query the sysObjects and sysdepends tables in the join, as shown below:
Shielded advertising]
