Ever wonder how to generate a Word document containing all the tables, their fields, datatypes, length, nullable or not, and their primary keys? Here's how to do it in tabular form, automatically.
You can obtain most of the information using a single T-SQL command:
Select * from information_schema.columns
You should be able to copy and paste this data directly into Word, though I find Excel makes it easier for me to view and analyze.
If you must submit queries like this often and need to convert them to Word or Excel, I find a product named WordConverter to be most useful. It is not free but I have found it to be quite useful for bulk file converstion. See http://softinterface.com/ for details.
Please note that I have no connection, formal or informal, to this company beyond that of customer.
