Friday 8 January 2016

What is a system database and what is a user database?

System databases are the default databases that are installed when the SQL Server is installed. Basically there are 4 system databases: Master, MSDB, TempDB and Model. It is highly recommended that these databases are not modified or altered for smooth functioning of the SQL System.
 A user database is a database that we create to store data and start working with the data.

No comments:

Post a Comment