how to print database diagram sql

Question

Hi

I would like to print the database diagram in sql. I'm using SQL Server Management Studio. What I did I right click on it, and select "View Page Breaks". I wanted to have the diagram in A3 Format. But when I tried to print it, I had 4 pages. Is there a way where I can print the whole diagram in just one page?

Thanks

Answer 1

Set the page zoom level on the print properties page (in addition to setting the page size to A3).

Switching back to the diagram with 'View Page Breaks' selected will show you when you have all the tables positioned properly onto one page.