Post reply

Table uses table

  • October 19, 2006 at 12:19 am

    #103255

    Both ApexSQLEditor and TOAD for SQL Server can show the tables a table uses or is dependent on. The stored procedure sp_depends shows everything but tables. Are there a way to show what tables a table depends on?

    Best regards

    Jesper

     

     

  • October 19, 2006 at 12:40 am

    #666708

    jseper

    check this system table - sysforeignkeys

    "Keep Trying"

  • October 19, 2006 at 9:36 am

    #666841

    In Enterprise Manager: Right-click on table, All tasks, Display dependencies

    In Query Analyzer: Expand database, User Tables, table, Dependencies

    Also see sp_fkeys in master db.

    Greg

     

    Greg

  • October 20, 2006 at 5:49 am

    #667020

    Of course, any of those methods depends on the fact that you have previously defined foreign keys among your tables.

  • October 24, 2006 at 7:16 am

    #667556

    You guys are not really from this planet are you? In TOAD for SQL Server (they got at freeware version J) you can see that in the Northwind database the table "Orders" uses the tables "Customers, Employees and Shippers". "Orders" is used by the table "Order Details" . I am looking for the code behind this functionality.

  • October 25, 2006 at 4:51 am

    #667803

    First of all you should be bit more civil.

    all those above mentioned methods will show the  table(s) that depend on other tables if proper Fkey relationships are set.

    "Keep Trying"

  • October 25, 2006 at 4:52 am

    #667804

    First of all you should be bit more civil.

    all those above mentioned methods will show the  table(s) that depend on other tables if proper Fkey relationships are set.

    "Keep Trying"

Viewing 7 posts - 1 through 6 (of 6 total)

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