create/delete database

create

默认属性创建

1 /************************
2 create database
3 ************************/
4 use master
5 go
6 create database store

 

自定义属性创建

 1 /************************
 2 create database
 3 ************************/
 4 use master
 5 go
 6 create database store
 7 
 8 on(name = 'store',
 9 filename = 'D:\sql_data\store.mdf',
10 size = 5mb,
11 maxsize = 50mb,
12 filegrowth = 5mb)
13 
14 log on(name = 'storelog',
15 filename = 'D:\sql_data\store_log.ldf',
16 size = 1mb,
17 maxsize = 10mb,
18 filegrowth = 1mb)

 

 

delete

1 /************************
2 delete database
3 ************************/
4 use master
5 go
6 drop database store
posted @ 2019-01-29 14:56  享受折腾  阅读(450)  评论(0)    收藏  举报