Options

How to systematically manage a Big List of Queries and Table

happy1001happy1001 Posts: 5
edited September 17, 2015 10:08AM in SQL Doc
Suppose someone has to work on a lot of different SQL Server Databases which have got a lot of Tables and Queries / Views inside them.

After a period of time, it becomes very difficult to remember exactly what kind of columns are present within a given Table and View.

Please suggest some method by which one can keep a systematic list of all the Tables and Views that are present within a SQL Server Database, along with the columns that are present within them.
Are there any Add-on products or services etc. available that helps in making this type of work systematic?

Currently I add comments to each queries inside SQL Server to remind me of what this query is doing, but this method is not great. I am looking for some better and more efficient methods.

Please share any ideas that you might have in this direction.

Thanks a lot
· Share on Twitter

Comments

  • Options
    Andrew PAndrew P Posts: 194 Silver 3
    Thanks for your post!

    Adding MS_Description extended properties is a start for documentation (as are comments), but I think that SQL Doc is the best tool for this. SQL Doc documents all of the database level objects such a stored procedures, tables (with their columns) along with the dependencies and full SQL script for any objects you select. Additionally you can configure the elements and objects that you want to exclude and include, and there are 4 formats that you can document into- PDF, DOC, HTML, and CHM (compiled help manual).

    Here is the product page: https://www.red-gate.com/products/sql-d ... t/sql-doc/
    and the documentation: http://documentation.red-gate.com/displ ... +databases

    SQL Doc comes with a 14 day free trial so you can evaluate whether it would fit your needs or not.

    Please let me know if that was helpful or if you have any questions or issues!

    I will also follow up with you via email if you have any problems with the tool :)

    Warm Regards,

    Andrew Pierce
    Product Support Engineer
    Andrew Pierce
    Technical Sales Engineer
    Redgate Software
    · Share on Twitter
  • Options
    happy1001happy1001 Posts: 5
    AndrewPierce wrote:
    Thanks for your post!

    Adding MS_Description extended properties is a start for documentation (as are comments), but I think that SQL Doc is the best tool for this. SQL Doc documents all of the database level objects such a stored procedures, tables (with their columns) along with the dependencies and full SQL script for any objects you select. Additionally you can configure the elements and objects that you want to exclude and include, and there are 4 formats that you can document into- PDF, DOC, HTML, and CHM (compiled help manual).

    Here is the product page: https://www.red-gate.com/products/sql-d ... t/sql-doc/
    and the documentation: http://documentation.red-gate.com/displ ... +databases

    SQL Doc comes with a 14 day free trial so you can evaluate whether it would fit your needs or not.

    Please let me know if that was helpful or if you have any questions or issues!

    I will also follow up with you via email if you have any problems with the tool :)

    Warm Regards,

    Andrew Pierce
    Product Support Engineer

    Thanks Andrew

    SQL Doc definitely looks quite helpful. I am checking it out.
    · Share on Twitter
Sign In or Register to comment.