Clever Geek Handbook

Can you print a graphical SQL Server View?

In SQL Server Management Studio, you can customize table charts with their own relationships. These diagrams can be viewed graphically as well as a print option. In the meantime, there is no need to know about it. ”

There are also views that are graphically configured in SQL Server Management Studio similar to diagrams. However, there is no print option in the views. My question is, is there a way to print a graphically oriented view structure in MS SQL Server?

+3


source to share


3 answers


Not directly. Use the Windows Snipping Tool or use the "Print Screen" key to copy the screenshot to the clipboard. Then edit / print the image.



+2


source


I'm just learning SQL and we just covered this topic, I think this is what you are looking for, from the console, just select all (*) from (name_of_view);

SELECT * from prod_view;


If you do it from the console (dos prompt (mySQL>), you get a graphical view (rudimentary graphics). I just did this and it works, but now I'm not entirely sure if I'm answering the correct question.

0


source


I don't know how to do this in SQL Server. If you don't mind using Microsoft Access and if you're not a bit of a hackish solution, you can create a new SQL Server project (called a Data Data Project in MS Access) by following these instructions and then open a query (a view is called a query in Access) ... The Query Access Designer has some visualization features that might be useful to you.

0


source






More articles:


All Articles