According to MS-DOCS about System information schema views, the schema columns definition have a warning note that says:
** Important ** 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.
Why can't INFORMATION_SCHEMA views be used to determine the schema of an object?
Is this information erroneous?
Best Answer
Yes, the statement there is inaccurate. I talk about this in this blog post (and complained about it in this ancient Connect item), where I implore people to use the
sys
catalog views overINFORMATION_SCHEMA
:In 2011, they said:
Now that we can submit pull requests for suggested changes to the documentation, it might be time for someone to make them pay attention to it again. 13 years is long enough.