-
Different data type for primary and foreign keys
Is it possible that Primary key and foreign keys hav diff. data type?
if No then is below eg valid...what length of deptid is diff in both the tableseg.emp table having (empid varchar2(10),deptid varchar2(25)) --deptid is foreign key dept table having (deptid varchar2(10),deptname varchar2(20) --deptid is primary key
Question asked by visitor sant
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules