Skip to Content (Press Enter)
2023-08-28 07-00-10
Paulo Torres
Champion
64Views
4Comments
Solved
Entity Attributes - How to know Parent of ForeignKey?
Question
Database

Hello All,

Someone know if it's possible to know the follow:

I have a table, I'll check the fields of this table in Entity_Attr. One of the fields is foreign Key and now I want to know which is the parent table of this ForeignKey.

It's possible to know this?

Thanks, Paulo Torres

3
0
16 Aug 2022
Copy Link
2023-08-28 07-00-10
Paulo Torres
Champion
Solution

Hi Kundan,

Not works like that but is similar.

In Type we have two SS Key, the second one after * is the SS Key of parent Table.

 Thanks anyway because your idea helped me to look for this field :)

See solution in context
3
0
16 Aug 2022
Copy Link
2026-03-12 06-20-48
KUNDAN CHAUHAN
Champion

Hi Paulo Torres,

check  foreign Key  attr. data type 

data type identifier name is the parent table name.

Here two table first one is Student and second is StudentImage

In StudentImage table Id is the foreign key

when we check Id data type then data type is Student Identifier

So here parent table of foreign key is :  Student

Thanks,

1
0
16 Aug 2022
Copy Link
2023-08-28 07-00-10
Paulo Torres
Champion
Solution

Hi Kundan,

Not works like that but is similar.

In Type we have two SS Key, the second one after * is the SS Key of parent Table.

 Thanks anyway because your idea helped me to look for this field :)

3
0
16 Aug 2022
Copy Link
2026-03-12 06-20-48
KUNDAN CHAUHAN
Champion
2023-08-28 07-00-10
Paulo Torres
Champion
4
0
16 Aug 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.