Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Register
Login
Formulation of sys.all_objects
Lajapathy Arun
Jul 03, 2012
1.6
k
0
0
Blogs
WhatsApp
We are going to see the Formula of sys.all_objects.
Formulation of sys.all_objects
sys.objects + sys.system_objects == sys.all_objects
You can verify by its count.
select count(*) from sys.objects
select count(*) from sys.all_objects
select count(*) from sys.system_objects
Thanks :)
Next Recommended Reading
Getting SQL Script of database object using sys.syscomments in SQL Server