What is the difference between system objects and user objects?
198615-Mar-2014
Updated on 21-Sep-2020
interview
Home / DeveloperSection / Interviews / What is the difference between system objects and user objects?
Home / DeveloperSection / Interviews / What is the difference between system objects and user objects?
Sumit Kesarwani
15-Mar-2014SQL 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.