This example query create table named as
db_name in this case I omitted
PRIMARY option and the first file is assumed as a primary file.The logical name of this file is
DB_data as I mentioned in query. File name parameter is for specify physical location for the database file.
db.mdf in Local disk
D: in my hard drive.
The original size of this file is 10MB ,Additional 20MB from disk may allocated by the system if it needed(
FILEGROWTH).
If
MAXSIZE option is not specified or it set to unlimited the file will dynamically use all space in disk as it grows.
If you need to use single transaction log file with specific logical name and destination you can use it as follows. parameters are specified are uses as same in
ON category.
Full Query for create Database statement
0 comments:
Post a Comment