ifexists(select*from sysdatabases where name='bbs') dropdatabase bbs go ----如果数据库已存在,则删除数据库------------ createdatabase bbs on ( name='bbs_data', filename='d:bs_data.mdf', size=1mb, maxsize=10mb, filegrowth=15% ) logon ( name='bbs_log, filename='d:bs_log.ndf', size=1mb, maxsize=10mb, filegrowth=15% ) go -----------创建数据库---------------- if exists(select * from sysobjects where name='emp') drop table emp go create table emp ( id int identity(1,1) primary key not null, name varchar(20) not null ) go
if exists(select * from sysdatabases where name=bbs) drop database bbsgo----如果数据库已存在,则删除数据库------------create database bbson( name=bbs_data, filename=d:bs_data.mdf, size=1mb, maxsize=1