--建库
use master
go
if exists(select * from sysdatabases where name='news')
drop database news
go
create database news
on primary
(
name='news',
filename='f:/DBProject/news.mdf',
size=5mb,
filegrowth=1mb
)
log on
(
name='news_log',
filename='f:/DBProject/news.ldf',
size=2mb,
filegrowth=10%
)
go
--建表呀
use news
go
if exists(select * from sysobjects where name='FirstLevelTitle')
drop table FirstLevelTitle
go
create table FirstLevelTitle
(
Id int not null,
TitleName varchar(50) not null,
Creator varchar(50) not null,
CreateTime datetime not null
)
go