createdb.sql

来自「信息管理系统」· SQL 代码 · 共 19 行

CREATE DATABASE TRANSPORT_SYS
ON (
NAME = TRANSPORT_INFO, 
FILENAME = 
'C:\Program Files\Microsoft SQL Server\MSSQL\data\TRANSPORT_INFO.MDF',
SIZE = 10MB,
MAXSIZE = 60MB,
FILEGROWTH = 10MB
)

LOG ON(
NAME = TRANSPORT_LOG,
FILENAME = 
'C:\Program Files\Microsoft SQL Server\MSSQL\data\TRANSPORT_LOG.LDF',
SIZE = 10MB,
MAXSIZE = 20MB,
FILEGROWTH = 6MB
)