Sql server information schema not updating
In any good programming reference, you will read that a developer has to document his code, not only for him/herself but also for the person who, ten years later will be asked to maintain it.
This would, of course, be made easier thanks to a good documentation of existing code.
In the best case, both of these processes should take documentation into account.
For instance, a unit test that fails whenever an undocumented object is found could be created.
The following figure depicts and summarizes development workflow as discussed above.
Here is a sample result of a query that selects every column from that table. Those four programmable components will be referred as built-in CRUD components in the remainder of the article.If everything is done well, then we are sure that each version of a database solution that is distributed always contains documentation.