Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 One Table as a Field of Another Table

Author  Topic 

Babax
Starting Member

2 Posts

Posted - 2010-12-22 : 15:10:24
The Table I intend to design, includes a field that is a separate table in it's own right for each record; it is a table of students of a college which for each student - that is, for each record - includes courses the student has passed with their associated details. I don't know how this field, can be included in the students table.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-22 : 15:26:18
You can use the XML data type, or just create another table and link them via a foreign key constraint.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Babax
Starting Member

2 Posts

Posted - 2010-12-27 : 01:06:56
I tried to do that via creating tables and relate them but each record has a separate table, and doing so implies creating so many tables. I think I should examine XML data.
Thank u.
Go to Top of Page
   

- Advertisement -