A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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)
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: complex table column type
How to use DetachedCriteria in multiple table?
parent key not found
JavaDb creating table error
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-2014