Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58

    Angry Unanswered: Checking columns level dependencies

    Hi all,
    Need a big favour, I have to collect information like
    TableName-> it's all columnNames--> dependent table name of EachColumn(where this column is refrenced)

    I have managed to get some info like:-

    select so.name as 'Table Name',sc.name as 'Column Name',st.[name], sc.length,sc.isnullable,so.crdate
    from syscolumns sc
    inner join sysobjects so on so.id=sc.id
    inner join systypes st on st.xtype= sc.xtype
    where so.xtype='U'
    order by so.name

    sp_depends and sp_MSdependencies is not returning me same fields..
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    I would start with sysobjects, syscolumns and sysreferences. Try the query and if you get stuck, let us know

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •