无标题1.sql

校园导游管理系统！！这个应该对很多人都比较有用

create database student
use student
create table 学生
(学号 char(4), 姓名 char(4),课程 char(4),成绩 integer 照片 v)
select * from 学生
create database xsglg
use xsglg
create table student_info
(student_in char(4)primary key,
student_name char(10),
student_sex char(2),
born_date datetime,
class_no char(4),
tele_number char(10) null,
ru_date datetime null,
address varchar(50) null,
comment text)
go 
create table result_info(
exam_no char(10)primary key,
student_id char(4) not null,
student_name char(10) not null,
class_no char(10) not null,
course_name char(10) null,
result float null
)
go 
create table  class_info
(class_no char(10) primary key,
grade char(10),
director char(10) null,
classroom_no char(10) null
)
go
create table [dbo].[gradecourse_info](
grade char(10) primary key,
course_name char(10) null,
result float null)
go
create table course_info
(course_no char(4) primary key,
course_name char(10) null,
course_type char(10) null,
course_des char(50) null)
go 
create table user_info
(user_id char(10) not null,
user_fwd char(10) not null,
user_des char(10) null)
go
use xsgl
select * from user_info
drop database xsgl
use student 
sp_renamedb xsglg,xsgl
select