Results 1 to 3 of 3

Thread: Table Dependencies

  1. Jul 5th, 2000, 08:33 AM #1
    DesertChip
    DesertChip is offline

    Thread Starter
    New Member
    Join Date
    May 2000
    Location
    Saudi Arabia
    Posts
    13

    Unhappy


    I have some master tables that other tables reference their PK as a forign key. Good example is "Cities" tables that can be referenced from "Customers" and "Suppliers" tables.

    Now, the question is, is there a away to get a list of those tables that reference "Cities" ??

    I'm using SQL server 7.0, ADO 2.5

    Regards
    Reply With Quote Reply With Quote
  2. Jul 5th, 2000, 09:26 AM #2
    RogerH
    RogerH is offline
    Lively Member
    Join Date
    Dec 1999
    Location
    Karlsruhe, Germany
    Posts
    122
    exec sp_depends 'tablename'

    Roger
    Reply With Quote Reply With Quote
  3. Jul 5th, 2000, 09:59 AM #3
    DesertChip
    DesertChip is offline

    Thread Starter
    New Member
    Join Date
    May 2000
    Location
    Saudi Arabia
    Posts
    13

    Ok, I found the answer in another site, here it is:

    SELECT Name FROM SYSOBJECTS,SYSREFERENCES
    WHERE ID = FKEYID
    AND RKEYID = (SELECT ID FROM sysobjects WHERE Name = TableName
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width