Devart Forums

Cannot find out how to print a table structure. Is it even possible?

Thanks

This can be performed as follows:

1. Right-click the table in Database Explorer and select 'Edit Table' from the popup menu.
2. Select 'File -> Print...' from the main menu.

This prints the SQL commands (CREATE etc.).
I need to print the structure (column names, data types etc.)

Thanks

You can perform the following:

1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Database Diagram -> Notation' section.
3. Select 'Name and Full Type' from the 'Field Details Level:' drop-down menu.
4. Click 'OK'.
5. Create a database diagram by selecting 'File -> New -> Database Diagram' from the main menu.
6. Drag'n'drop the table(s) onto the diagram.
7. Select 'File -> Print...' from the main menu.

Thanks for the answer but ... output is not satisfactory!
A structure print is meant for documentation purposes.
So no columns for Allow Null, Default AND ESPECIALLY Description
render the print -almost- useless.

Thanks

PS. It's amazing how 21 century tools accomplish amazing things but fail on the most rudimentary.
30 years ago one would write in DBase III+ (!) DISP STRU TO PRINT , et voila!

Unfortunately, there is no such a possibility. However, you can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/1770 ... sql-server

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.