Ankur Jain
What is the difference between system objects and user objects?
By Ankur Jain in Databases & DBA on Aug 18 2014
  • Kml Surani
    May, 2015 13

    "System objects" are the SQL server internal databases / tables / views etc. which SQL server requires to function. Examples would be the master, model and msdb databases, or database level objects in the sys schema. You might elect to hide them just to keep them out of the way in the object explorer."

    • 0
  • Munesh Sharma
    Oct, 2014 9

    "System objects" are the SQL server internal databases / tables / views etc. which SQL server requires to function. Examples would be the master, model and msdb databases, or database level objects in the sys schema. You might elect to hide them just to keep them out of the way in the object explorer.

    • 0
  • Ankur Jain
    Aug, 2014 18

    SQL Server creates system objects during the installation process. They are part of the system, and most of them are necessary for SQL Server to function properly. Whereas system objects are part of the SQL Server system, you create user objects. User objects include the databases, stored procedures, functions, and other system objects that you build.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS