创建数据库

USE master;GOCREATE DATABASE ToyUniverseON ( 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 ToyUniverseADD FILE(    NAME = ToyUniverse_Data2,    FILENAME = 'F:\Project Files\SQL Server\DATA\ToyUniverse_Data2.mdf',    SIZE = 10,    MAXSIZE = 50,    FILEGROWTH = 5    )

 

--增加一个数据库日志文件ALTER DATABASE ToyUniverseADD 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

结果：