建库语法

use master
go
if exists(select * from sysdatabases where name='by3g')
drop database by3g
go
create database by3g
on primary
(
   name='by3g_data',
   filename='f:\by3g_data.mdf',
   size=50mb,
   maxsize=200mb,
   filegrowth=20%
),
(
   name='by3g1_data',
   filename='e:\by3g_data.ndf',
   size=50mb,
   maxsize=200mb,
   filegrowth=20%
)
log on
(
   name='by3g_log',
   filename='f:\by3g_log.ldf',
   size=5mb,
   maxsize=20mb,
   filegrowth=10%
)
go

use by3g
go
if exists(select * from sysobjects where name='stuinfo' and xtype='u')
drop table stuinfo
go
create table stuInfo
(
   stuId int primary key identity(1000,1),
   stuName varchar(20) not null,
   stuAge int not null check(stuage>=0 and stuage<=150),
   stuSex char(2) not null,
   stuEmail varchar(100),
   stuAddress varchar(200)
)