Syntax :
Create Database [Database Name]
Eg : Create Database Sample
Now the database will be created with the name of Sample.
And the two files will be created automatically (i.e) ldf and mdf.
mdf - Master Data File
ldf - Log Data File
These two files will be located in SQL server installed location(i,e default location)
Unless you specified the path
No comments:
Post a Comment