Post reply

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

  • 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 2 posts - 1 through 3 (of 3 total)

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