Create table [dbo].项目成绩表 NOT NULL,
[xm_id] char NULL,
[xm_name]char NULL,
[ys_cj] char NULL,
[ys_pm] char NULL,
[js_cj] char NULL,
[js_pm] char NULL,
Primary key(ydy_id),
Foreign key(xm_id)
)
“)”附近有语法错误 应为references
foreign key是表与表之间的约定关系,定义外键得在关联表,示例:FOREIGN KEY(Sno) REFERENCES Student(Sno)
建立外键要指定外键对应表,示例:
create table course(
course_id varchar(20),
deptnames varchar(20),
credits int,
foreign key(deptnames) references department(dept_name))