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
How to systematically manage a Big List of Queries and Tables in SQL Server ?
September 12th, 2015 9:26pm
You can use SVN Tortoise or VSS repository where you can upload the list of codes and there versions.
Here in the link comparison:
http://stackoverflow.com/questions/1101706/svn-vs-vss-vs-cvs-comparing-help
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 12:31am