About this question
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?What is INFORMATION_SCHEMA SQL server?