7-10.sql

来自「包括本书所有的源代码。所有程序均在Windows 2000+IIS5.0+SQL」· SQL 代码 · 共 14 行

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)
)