Dependencies

External Article

Dependencies and References in SQL Server

  • Article

It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you need to work out what process is accessing that view you want to alter, or maybe find out whether that table-type you wish to change is being used. What are all these dependencies? How do you work out which are relevant? Phil Factor explains.

2015-10-23

3,238 reads

External Article

Identifying Object Dependencies in SQL Server

  • Article

Is there a way to identify which objects are dependent on other objects within a SQL Server database? I need to modify the table structure to add new columns. However, before making any changes I want to make sure that I understand all the object dependencies. Is there a way in SQL Server 2008 to quickly identify all the object dependencies?

2009-06-26

3,798 reads

Blogs

Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning

By

Join us on December 8th at 10am Pacific time for an exciting new webinar!...

Daily Coping 3 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 2 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Foreign key in the column values of another table

By teb

I have trouble in writing a SQL query. I have a data table with...

How to increase performance to load a factless date-date-interval table

By svenflock

Hi all, I am currently having performance issues by populating one of my factless...

Linked Server Error

By dhara

Hi Experts, I am getting the following error when i am trying to test...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers