7-10.sql

来自「asp开发 asp开发 asp开发 asp开发」· 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)
)