Home » RDBMS Server » Server Administration » Help !! Resolving Primary key..?
Help !! Resolving Primary key..? [message #373210] Wed, 04 April 2001 08:27
Nick
Messages: 64
Registered: February 2000
Member
Hi !!

Kindly help me..

I have one table having a composite Primay Key on two columns. this key was made to refer two tables only.

my table structure is like

table_name1
( col1 ( this is part of Composite PK)
col2 ( this is FK from other table but part of
Composite PK)
col3
...
...
...
)

if i want to refer only col1 in my other 40 tables how it is possible. i can not possibly refer the other field due to high records insertion in my database.

kindly , do help me if somebody has a solution to reslove this problem

...
Previous Topic: Sort query according to a date value (also take time in account)
Next Topic: hint
Goto Forum:
  


Current Time: Mon Dec 23 05:59:46 CST 2024