In the following topic:http://msdn.microsoft.com/en-us/library/ms186224.aspxFor 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.
Operating System Language
Steps to Reproduce