create image for database diagram in sql server

sql sql-server-2008 database-diagram
PoliDev picture PoliDev · Apr 5, 2013 · Viewed 14.9k times · Source

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?

Answer

steoleary picture steoleary · Apr 5, 2013

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.

Related questions

What does a dashed / dotted relationship line represent in SQL Management Studio - Database Diagram

I'm looking at an existing database in Microsoft SQL Server Management Studio, and in the Database Diagram there is one relatioship that appears with a dashed or dotted line. The other relationships are all solid lines. What does the dashed …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More