SQL之-建库、表、建约束、关系SQL基本语句大全.docVIP

SQL之-建库、建表、建约束、关系、部分T-sql语句 --建库 if exists(select * from sys.sysdatabases where name=wf) begin use master drop database wf end go create database wf on (name=Nwf,filename=NE:\MyCode\ETC收费站\ETC收费站\ETC_Data\wf.mdf,size=3mb,maxsize=unlimited,filegrowth=1) --建库 if exists(select * from sys.sysdatabases where name=wf) begin use master drop database wf end go create database wf on (name=Nwf,filename=NE:\MyCode\ETC收费站\ETC收费站\ETC_Data\wf.mdf,size=3mb,maxsize=unlimited,filegrowth=1) log on (name=Nwf,filename=NE:\MyCode\ETC收费站\ETC收费站\ETC_Data\wf_log.ldf,size=3mb,maxsize=unlimited,filegrowth=1) g