sql中建库建表的sql语句

 --建库
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