Wednesday, October 7, 2009

for Genrating Database tables and view structor in word file

Many time SQL Developer wants to create the Structure of Database in a single shot there is script for this. it will create structure in table format for all tables and views resides in particular Database. with page index in the front of Document.
so you can go directly to table and view structure from Index table


Copy and paste in SQL server Query Analyzer
then Go to Query-> result to file-> give file name with .doc extension
then press F5

please link for that file....
http://cid-c8bde36bd5695847.skydrive.live.com/self.aspx/Bloggers%20Files/15102010-1.txt