USE MASTER GO --创建数据库文件存放目录 EXEC XP_CMDSHELL 'MKDIR D:/LOANSTUMIS' IF EXISTS(SELECT * FROM SYSDATABASES WHERE NAME = 'LOANSTU') DROP DATABASE LOANSTU GO --创建数据库 CREATE DATABASE LOANSTU ON ( NAME = 'LOANSTU_DATA', FILENAME = 'D:/LOANSTUMIS/LOANSTU_DATA.MDF', SIZE = 10MB, FILEGROWTH = 1MB, MAXSIZE = 100MB ) LOG ON ( NAME = 'LOANSTU_LOG', FILENAME = 'D:/LOANSTUMIS/LOANSTU_LOG.LDF', SIZE = 10MB, FILEGROWTH = 1MB, MAXSIZE = 100MB ) GO USE LOANSTU GO --返回影响的行数提示 SET NOCOUNT ON --建表 IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'TB_ADMIN') DROP DATABASE TB_ADMIN IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'TB_DLRZ') DROP DATABASE TB_DLRZ IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'TB_ZZJG') DROP DATABASE TB_ZZJG IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'TB_ZXXX') DROP DATABASE TB_ZXXX IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'TB_JTXX') DROP DATABASE TB_JTXX IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'TB_BYQX') DROP DATABASE TB_BYQX IF EXISTS(SELECT * FROM SYSOBJECTS WHERE NAME = 'TB_HTXX') DROP DATABASE TB_HTXX GO --创建管理员信息表 CREATE TABLE TB_ADMIN ( ADMINID VARCHAR(15) PRIMARY KEY NOT NULL, ADMINNAME VARCHAR(10) NOT NULL, ADMINPASSWORD VARCHAR(20) DEFAULT('abc123') NOT NULL