使用 create 命令建立数据库v， 并利用sp_helpdb查看数据库文件

create database v

on primary

(name = v,

filename='D:\v.mdf',

size=3mb,

maxsize=10mb,

filegrowth=2mb

)

log on

(name = v_log,

filename='D:\v_log.ldf',

size=3mb,

maxsize=10mb,

filegrowth=2mb

)

go

sp_helpdb v

go