Post reply

view related tables

  • January 18, 2008 at 9:42 am

    #182821

    How can I get a view of all related tables of a database?

  • January 18, 2008 at 10:14 am

    #769783

    you could try the stored proc sp_fkeys [tablename]

    that will list all the tables that reference any column in the selected table via a foreign key reference...

    if you ment a GUI kind of view, I'm not sure about it in 2005; i think the designer went away in 2005.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 18, 2008 at 10:32 am

    #769786

    If I understand the question, you can simply use the Database Diagrams to see all the tables and their relationships. Assuming those relationships in your database are all through primary & foreign keys. Triggers and code will not be displayed.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 18, 2008 at 10:43 am

    #769791

    Thanks guys. That was a very fast reply. Database diagram did it. 🙂

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

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