使用T-SQL创建数据库

一： 使用T-SQL语句创建数据库

例1

    CREATE DATABASE RShDB
    ON
    (
       NAME = RShDB_Data,
       FILENAME = 'D:RShDB_Data\RShDB_Data.mdf',
       SIZE = 10,
       MAXSIZE = 30,
       FILEGROWTH = 5
    )
    LOG ON
    (
       name = RShDB_log,
       filename = 'D:RShDB_Data\RShDB_log.ldf',
       size = 3,
       maxsize = 12,
       filegrowth = 2
    )

例2

    create database Students
    on primary....................................................................................................................