It’s database introduced by Microsoft in the
year 1994. It is a highly compatible database which developing application
using dot .NET language. It was a case insensitive database. SQL Server is
a collection of database where each database is collection of objects like
Tables, Views,
and Procedures etc. In
SQL server users have an option of creating their own databases in ‘n’
number.
These databases are classified into two types:
(1)
System Databases
(2)
User
Databases
System
Database: - These databases are used by SQL
Server for its functionality, those are
(I) Master (II) Model (III) MSDB (IV) TempDB
User database: - These are databases, which are created by user’s to perform their operations. We can create them at any time as well as destroy them.
(I) Master (II) Model (III) MSDB (IV) TempDB
User database: - These are databases, which are created by user’s to perform their operations. We can create them at any time as well as destroy them.
Happy New Year!
ReplyDelete