Sql server® 2012 t-sql fundamentals


File extensions .mdf, .ldf, and .ndf



Download 10,93 Mb.
Pdf ko'rish
bet58/443
Sana26.01.2022
Hajmi10,93 Mb.
#411755
1   ...   54   55   56   57   58   59   60   61   ...   443
Bog'liq
BookSQL

File extensions .mdf, .ldf, and .ndf

The database file extensions .mdf and .ldf are quite straightforward. The extension .mdf 

stands for Master Data File (not to be confused with the master database), and .ldf stands 

for Log Data File. According to one anecdote, when discussing the extension for the sec-

ondary data files, one of the developers suggested, humorously, using .ndf to represent 

“Not Master Data File,” and the idea was accepted.



Schemas and Objects

When I said earlier that a database is a container of objects, I simplified things a bit. As illustrated in 

Figure 1-8, a database contains schemas, and schemas contain objects. You can think of a schema as a 

container of objects such as tables, views, stored procedures, and others. 

dbo

Sales


HR

User Database

Schema

Objects


FIGuRE 1-8

  A database, schemas, and database objects. 

www.it-ebooks.info




Download 10,93 Mb.

Do'stlaringiz bilan baham:
1   ...   54   55   56   57   58   59   60   61   ...   443




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©hozir.org 2024
ma'muriyatiga murojaat qiling

kiriting | ro'yxatdan o'tish
    Bosh sahifa
юртда тантана
Боғда битган
Бугун юртда
Эшитганлар жилманглар
Эшитмадим деманглар
битган бодомлар
Yangiariq tumani
qitish marakazi
Raqamli texnologiyalar
ilishida muhokamadan
tasdiqqa tavsiya
tavsiya etilgan
iqtisodiyot kafedrasi
steiermarkischen landesregierung
asarlaringizni yuboring
o'zingizning asarlaringizni
Iltimos faqat
faqat o'zingizning
steierm rkischen
landesregierung fachabteilung
rkischen landesregierung
hamshira loyihasi
loyihasi mavsum
faolyatining oqibatlari
asosiy adabiyotlar
fakulteti ahborot
ahborot havfsizligi
havfsizligi kafedrasi
fanidan bo’yicha
fakulteti iqtisodiyot
boshqaruv fakulteti
chiqarishda boshqaruv
ishlab chiqarishda
iqtisodiyot fakultet
multiservis tarmoqlari
fanidan asosiy
Uzbek fanidan
mavzulari potok
asosidagi multiservis
'aliyyil a'ziym
billahil 'aliyyil
illaa billahil
quvvata illaa
falah' deganida
Kompyuter savodxonligi
bo’yicha mustaqil
'alal falah'
Hayya 'alal
'alas soloh
Hayya 'alas
mavsum boyicha


yuklab olish