Upon reading INFORMATION_SCHEMA vs sysobjects , I wanted to ask the question:
SQL Server 2005/2008 - Why is the sys.sysobjects view available to users without the schema name?
which seems to be already asked but I do not find that the answers answered the question(asked).
Why sysbjects is available as sys.sysobjects if sys schema did not exist in earlier versions of SQL Server?
(the explanation was that it is for backward compatibility with earlier versions of SQL Server)
Then, the answer by Barry:
SQL Server looks for objects in the following order:
- sys schema
- users schema (This is different for Stored Procs - it will look in the stroed procs schema rather than the users schema.
- dbo schema
has left pending the question by Shaun in comments:
Why sys.objects is not queriable without "sys." pefix (as objects)?
What are default schemas being searched by SQL Server and in which order?