7-10.sql

asp开发 asp开发 asp开发 asp开发

CREATE TABLE basicinfo
(
	stu_id 		int Identity(1001,1) PRIMARY KEY,
	Firstname 	VARCHAR(10) ,
	Lastname 	VARCHAR(10)
)
CREATE TABLE history
(
	historyid     	int PRIMARY KEY,
	stu_id     		int,
	stu_grade		int
	FOREIGN KEY(stu_id) REFERENCES basicinfo(stu_id)
)