Composite primary Key

[janet]

hi...

i am creating a table :
create table student_content
(student_id varchar(10) references student_info
(student_id),
story_id numeric(4) references story_table(story_id),
status_student varchar(5),
story_original varchar(100),
story_status_date date,
story_word_count numeric(100),
composite primary key(student_id, story_id));

i have 3 tables:
1. student_info, PK -- > student_id
2. story_table, PK --> Story_id
3. student_content, PK--> (student_id, story_id)

can this be possible. i am getting error in this???

thanks a lot!

[Aaron Bertrand - MVP]

> i am creating a table :

In what database, PostGreSQL, Access, FoxPro, SQL Server? What version?

> (student_id varchar(10) references student_info
> (student_id),

Shouldn't this be FOREIGN KEY REFERENCES student_info(student_id)?

> can this be possible. i am getting error in this???

WHAT ERROR?