How to systematically manage a Big List of Queries and Table

happy1001

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

Andrew P

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

happy1001

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.