3
Reply

What is the difference between system objects and user objects?

Ankur Jain

Ankur Jain

10y
2k
0
Reply

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

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

    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.