Sql server information schema not updating ethics dating subordinate
This view will return a list of objects with missing documentation either about itself or about one or more of its columns. We would edit this statement in order to update record and make it disappear from records returned by that view.
This goal will be achieved by table to get back attributes and their description of a particular object.
For instance, a unit test that fails whenever an undocumented object is found could be created.
It will use have almost the same signature as built-in CRUD components for extended events management. First, there is the database name in which our stored procedure should apply modifications.
If no one is provided, it will take current database name.
Then, there is the name of the extended property on which we want to operate followed by common which, when set to 1, tells stored procedure not to perform those checks.
In that case, all accepted parameter associations that are defined in the stored procedure body will affect corresponding extended properties.If everything is done well, then we are sure that each version of a database solution that is distributed always contains documentation.