sql_存在检测、建库、_建表、约束、外键、级联删除.docVIP

sql?存在检测、建库、?建表、约束、外键、级联删除 use mastergo --判断删除已存在的数据库 stuDBif exists(select * from sysdatabases where name = stuDB)drop database stuDB --新建数据库 stuDBcreate database stuDBon primary(name=stuDBdata,filename=d:\sql\stuDBdata.mdf,size=5mb,maxsize=unlimited,filegrowth=10%)log on(name=stuDBlog,filename=d:\sql\stuDBdata.ldf,size=1mb,maxsize=unlimited,filegrowth=1mb)go --打开use stuDBgo --判断是否已存在要创建的表if exists(select * from sysobjects where name = stuinfo)drop table stuInfo --新建表create table stuInfo(stuName varchar(20) not null,stuNo varchar(20) not null,stuSex varchar(20) no