创建数据库.txt

来自「介绍了一些数据库中常用的语句」· 文本 代码 · 共 32 行

CREATE  DATABASE  test
 ON  PRIMARY
      (NAME=test_data ,
       FILENAME=’ e:\刘海波\ test \test_data.mdf’ ,
       SIZE=5MB,          
       MAXSIZE=50MB,     
       FILEGROWTH=15%), 
     FILEGROUP  SECOND
       (NAME= test_dada1 ,
         FILENAME=’ e:\刘海波\ test \test_data1.ndf’ ,
         SIZE=10MB,
         MAXSIZE=1GB,
         FILEGROWTH=10MB) ,
       (NAME= test_dada2 ,
        FILENAME=’ e:\刘海波\ test \test_data2.ndf’ ,
        SIZE=10MB,
        MAXSIZE=1GB,
        FILEGROWTH=10MB ) ,
    FILEGROUP  THIRD
     (NAME= test_dada3 ,
      FILENAME=’ e:\刘海波\ test \test_data3.ndf’ ,
      SIZE=10MB,
      MAXSIZE=1GB,
      FILEGROWTH=10MB)
LOG  ON
   (NAME=test_log,
    FILENAME=’ e:\刘海波\ test \ test_log.ldf’,
    SIZE=10MB,
    MAXSIZE=100MB,
    FILEGROWTH=10MB )
COLLATE  Chinese_PRC_CI_AS