T-SQL_1 创建数据库

 

创建数据库的T-SQL语句如下:

 

use mastergo--如果已经存在MyTestsDB先删除--if exists(select * from sysdatabases where name = 'MyTestsDB')drop database MyTestsDBgocreate database MyTestsDBon primary(--逻辑名称--name = 'MyTestsDB1',--物理位置--filename = 'F:/赵宁勃/SQLs/MyTestsDB1.mdf',--大小--size = 5MB,--最大体积--maxsize = 20MB,--文件增长页分比(或者指定1MB, 即每次到上限便自动增长1MB)--filegrowth = 1),(name = 'MyTestsDB2',filename = 'F:/赵宁勃/SQLs/MyTestsDB2.ndf',size = 5MB,maxsize = 20MB,filegrowth = 1)log on(name = 'MyTestsDB1_log',filename = 'F:/赵宁勃/SQLs/MyTestsDB1.ldf',size = 1MB,maxsize = 5MB,filegrowth = 1),(name = 'MyTestsDB2_log',filename = 'F:/赵宁勃/SQLs/MyTestsDB2.ldf',size = 1MB,maxsize = 5MB,filegrowth = 1)go