A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Mikado Method
this week in the
Agile and other Processes
complex table column type
Joined: Apr 24, 2006
Apr 24, 2006 15:00:00
Suppose I want to create 2 tables -- Department, Student
in which "department" table contains a group of "student".
How to do the "create table" statement for "department" ? Please help.
Joined: Mar 20, 2006
May 07, 2006 04:24:00
In your case it is prefarable to create the tables like :
Create table Dept(
CONSTRAINT DEPT_DEPTID_PK PRIMARY KEY (DEPT_ID));
Create table Student(
CONSTRAINT STUDENT_STUDID_PK PRIMARY KEY (STUD_ID),
CONSTRAINT STUDENT_DEPTID_FK FOREIGN KEY (DEPT_ID)REFERENCES Dept(Dept_id)
I agree. Here's the link:
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: complex table column type
How to use DetachedCriteria in multiple table?
JavaDb creating table error
parent key not found
Please help me in creation of tables
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013