Ok I ve been asked to generate a schema for a database that contains 20+ tables
I ve used SQLServer Management studio to extract out the database schema but cannot export it into word
If I copy it as a diagram the tables are too small
Does anyone know how to extract the schema from a sql server database so that it is presentable to a project manager
If you have Visio you can use the reverse engineer functionality to generate a schema diagram of your database which you can then format to make look presentable. If required this will then paste nicely into word.
More information here
Another way is to simply take a screen shot of the database diagrams...
You can create more than one database diagram, each containing part of the schema. Make those small enough to see.