create database.sql

来自「数据库文件。对sql数据库的基本用法和创建做了介绍」· SQL 代码 · 共 53 行

create database 定单管理数据库
on
primary (
   name=表1,
   FILENAME ='c:\定单管理数据库\order1',
   size=10MB,
   maxsize=20,
   filegrowth=20),
  (name=表2,
    FILENAME ='c:\定单管理数据库\order2',
   size=10MB,
   maxsize=20,
   filegrowth=20),
 filegroup group1
   (name=表3,
    FILENAME ='d:\定单管理数据库\order3',
   size=10MB,
   maxsize=20,
   filegrowth=20),
  ( name=表4,
    FILENAME ='d:\定单管理数据库\order4',
   size=10MB,
   maxsize=20,
   filegrowth=20),
 filegroup group2
  (name=表5,
    FILENAME ='f:\定单管理数据库\order5',
   size=10MB,
   maxsize=20,
   filegrowth=20),
  (name=表6,
    FILENAME ='f:\定单管理数据库\order6',
   size=10MB,
   maxsize=20,
   filegrowth=20)
  
 LOG ON
   (name=orderlog1,
    FILENAME ='c:\定单管理数据库\orderlog1',
    size=10MB,
    maxsize=20,
    filegrowth=20),
   (name=orderlog2,
    FILENAME ='c:\定单管理数据库\orderlog2',
    size=10MB,
    maxsize=20,
    filegrowth=20)