On SQL Server Management Studio
In the Database Diagram, right click and select ‘View Page Breaks’
Then from main window menu select, File > Page Setup
Select Page Size and Orientation – A3 and Landscape are most likely best options.
And Print Scale – this is the % value that should hopefully enable you to fit all tables onto one page.