[DOC] : INFORMATION_SCHEMA.TABLES gives improper warning about schema by aaronbertrand

In the following topic:

http://msdn.microsoft.com/en-us/library/ms186224.aspx

For the TABLE_SCHEMA column, this warning appears:

<snip>
Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view.
</snip>

This warning is not correct. If you look at the object_definition of INFORMATION_SCHEMA.TABLES, it points to the same schema_id column as sys.objects, so there is no situation where sys.objects would be correct but INFORMATION_SCHEMA would be incorrect.

Perhaps this is a lingering piece of information from a time when objects could be orphaned in a way that INFORMATION_SCHEMA views were not updated (e.g. my messing with system tables directly)?

Now, I realize that we do want to push people toward the catalog views, however it is for a different reason. We are not afraid that INFORMATION_SCHEMA views are incorrect, but rather that they are incomplete. For example, the INFORMATION_SCHEMA views contain no information about newer features such as included columns and filtered indexes.