8

I am using SQL Server 2005 database with SQL Server Management Studio.

Is there a way to hide a relationship between two tables in the diagram without actually deleting the relationship from the database? Any help will be most appreciated.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user179490
  • 155
  • 1
  • 1
  • 14
  • 1
    Why would you want to? That's like saying 'this relationship is important enough to actually exist but we dont want people working with the database to know about it'. – workmad3 Oct 26 '09 at 12:15
  • 2
    Well in my case, people DO know about it but do not want it to be visible because it creates a lot of mess when printed. Just for readibility. – user179490 Oct 26 '09 at 12:19
  • 3
    All our tables have a 'lastedited' link to user. As soon as you want to make a schema with user (for any other reason), the schema is a mess – Boris Callens May 11 '15 at 14:10

1 Answers1

0

I'm not aware of any way to do this without dropping the FK relationship. Short of using tipp-ex on the monitor :-) You do this at your own risk though :-)

Chris J
  • 30,688
  • 6
  • 69
  • 111