sqlserver数据库的创建文档 .txt

这是一个图书管理系统

create table books (
ID int identity,
BookName varchar(20),
Press varchar(20),
Author varchar(20),
address varchar(20),
PressDate datetime,
Price NUMERIC(5,2),
books_count NUMERIC(2),
Com varchar(20),
borrowed_count NUMERIC(2),
constraint ID_Contraint_PK primary key ( ID ));

insert into books (bookname,press, author,address,pressdate,price,books_count ,com)
values ('java','南昌航空',1,1,2005-12-12,1,12,1)

select * from books;

create table bookBrowse (
ID number(3),
StudentName varchar2(40),
BookName varchar2(40),
ReturnDate Date,
BorrowDate Date,
Com varchar2(40),
Is_Returned char(2),//设置默认直为‘否’
constraint ID_BookBrowse_Containt primary key ( ID ));


create table UserTable(
ID int identity,
UserName varchar(40),
Password varchar(40),
Power varchar(40),
constraint ID_User_Containt primary key ( ID ));