数据库编码.docVIP

use master go CREATE DATABASE db_Library ON (NAME= db_Library_data, FILENAME=d:\17-zhaojingjuan\db_Library_data.mdf, SIZE=10MB, MAXSIZE=300MB, FILEGROWTH=10%) LOG ON (NAME= db_Library_log, FILENAME=d:\17-zhaojingjuan\db_Library_log.ldf, SIZE=5MB, MAXSIZE=200MB, FILEGROWTH=2MB) USE db_Library go create table tb_booktype (classnum int primary key, classname char(20), ); go create table tb_book ( booknum int primary key, classnum int , bookname char(15) unique, author char(20), publishclub char(20), price float(2), acount int, FOREIGN KEY (classnum) REFERENCES tb_booktype(