3
Reply

What is the difference between system objects and user objects?

Ankur Jain

Ankur Jain

Aug 18, 2014
1.9k
0

    "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."

    Kml Surani
    May 13, 2015
    0

    "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.

    Munesh Sharma
    October 09, 2014
    0

    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.

    Ankur Jain
    August 18, 2014
    0