Post reply

Finding a Columns Dependencies... in one DB .. or more than one

  • March 28, 2006 at 8:12 pm

    #112566

    Hi,

    I need to find the dependencies(in & out both) on a particular column in a table... I know you can find for an object but how can we do the same for column... I need to find with reference to a particular db .. if you know a script that will be great... its part of design/changes we need to make to our system... if i can find it with respect to all db it would be great...

    Thanks

  • March 29, 2006 at 7:20 am

    #629476

    You should be able to use the INFORMATION_SCHEMA views to determine most if not all of the dependencies.  The views can be seen in the master db and used in any db by qualifying the reference with the db in which you are interested.  Check BOL for details...

    e.g.

    SELECT *

    FROM mydb.INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

     

  • March 29, 2006 at 9:12 am

    #629525

    Well, I want to know the dependent objects like procedures,functions which use this column.... Will this INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE view help me get that apart from the column constraints??

    Thanks.. anyone else has seen something like this bfore.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply