Post reply

How to add sys table to diagram ?

  • September 29, 2011 at 9:34 am

    #245617

    I tried to add a sys table to a SQL Server diagram in SSMS. So far, it looks like impossible. Is there a work around, a trick to add ?

    Thanks

  • September 29, 2011 at 9:44 am

    #1388467

    Drag it ....onto the diagram window...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • September 29, 2011 at 9:54 am

    #1388476

    I tried it, but it does not work. It's actually a sys view, not a sys table. When I try to drag it, it changes mousepointer to prohibiting circle with a line.

  • September 29, 2011 at 10:08 am

    #1388484

    As views are not physical tables as they are just the query result sets from multiple tables they don't let you to make relationships.

    Try making that view to indexed view but I'm sure that you cannot make system views to indexed views.

    So that only solution in my mind is copy the data from view to another table and use it in the database diagram( not sure how it is useful in your environment).

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

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

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