Sql server information schema not updating
The information schema consists of a set of views that contain information about the objects defined in the current database.
The following figure depicts and summarizes development workflow as discussed above.
, which contains read-only views that you can use for introspection into your database's tables, columns, indexes, and views.
This notion of an information schema is part of the SQL standard, which means it is portable and will remain stable.
This is certainly the reason why we can find a feature called Extended Properties since (at least) SQL Server 2005 version.
You can imagine it as metadata associated with a given database object (and even a database itself).