[SQL Server 系] T-SQL数据库的创建与修改

创建数据库

USE master;
GO
CREATE DATABASE ToyUniverse
ON 
( NAME = ToyUniverse_Data,
    FILENAME = 'F:\Project Files\SQL Server\DATA\ToyUniverse_Dat.mdf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 )
LOG ON
( NAME = ToyUniverse_Log,
    FILENAME = 'F:\Project Files\SQL Server\DATA\ToyUniverse_Log.ldf',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB ) ;
GO

删除数据库

DROP DATABASE ToyUniverse

修改数据库

ALTER DATABASE ToyUniverse
ADD FILE
(
    NAME = ToyUniverse_Data2,
    FILENAME = 'F:\Project Files\SQL Server\DATA\ToyUniverse_Data2.mdf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5    
)

 

--增加一个数据库日志文件
ALTER DATABASE ToyUniverse
ADD FILE
(
    NAME = ToyUniverse_Log2,
    FILENAME = 'F:\Project Files\SQL Server\DATA\ToyUniverse_Log2.mdf',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5    
)

修改后：

 

使用SQL语句查看数据库

SELECT DATABASEPROPERTY('ToyUniverse','Version')

结果：

 

 

使用存储过程查看数据库

sp_helpdb

结果：