16

I have created database diagram in sql server. But I have to take 15 more tables in db diagram. Then i take screenshot. But i can't take screenshot more than 5 table. So I take screenshot 2 or more times. If sql server is automatically create image and if it is in single screenshot means it is ok. Any way to do this?

enter image description here

This is my screenshot. I ask Any chance to take 15 tables in single screenshot through sql server?

David Duponchel
  • 3,959
  • 3
  • 28
  • 36
PoliDev
  • 1,408
  • 9
  • 24
  • 45

1 Answers1

38

Yes, you can do this. Just open the diagram in SSMS, right click on the diagram surface (on the blank space between the tables, not the tables themselves) and then click the "Copy Diagram To Clipboard" option.

You can then paste the full diagram into whatever program you want.

steoleary
  • 8,968
  • 2
  • 33
  • 47
  • 7
    I have like 50 odd tables.. While copy pasting it to Paint, I don't see table contents(columns) in the copied content. I see onlt table headings with black box. Should i do anything else? – Nameless Nov 14 '17 at 06:23
  • 1
    Nice feature, but when I paste it in a graphics tool I get an image with a horribly low resolution... not able to read anything – thomasgalliker Nov 07 '19 at 08:04
  • 1
    Did anyone ever answer the low resolution question? How do you raise the resolution of the image that's exported? – Ralph Yozzo Jun 25 '21 at 20:47
  • 1
    When you select "Copy Diagram To Clipboard", SSMS use the current zoom. If you want a "higher resolution", then select zoom 100% or more and reclick right button, select "Copy Diagram To Clipboard" and it will work. Very confusing "export to image" method ... – aprovent Aug 18 '21 at 15:38