How can one search for foreign key table for a column?
-
Use Business Objects and Links definitions
-
Query using the column ‘Foreign Key Table’ in tools
-
Use Flat Tab
-
Using Business components and Join definitions
In Siebel Tools, each column object in a table has a 'Foreign Key Table' property that shows which table this column references (if it's a foreign key). To search for the foreign key table for a specific column, you query this column property in Tools - it directly shows the related table. Business Objects, Links, Business Components, and Join definitions are higher-level objects that USE foreign key relationships, but the FK Table column property is the direct way to see which table a column references. Flat Tab is a UI tab layout feature, unrelated to FK relationships.
In Siebel Tools, the Columns list (under a table definition) has a 'Foreign Key Table' property/column that you can add to the list view and query directly, letting you quickly find which table a given column's foreign key points to. Business Object/Link definitions and Join definitions describe relationships at the business-component level, not raw table-column foreign key metadata, so they're not the direct way to look this up; 'Flat Tab' isn't a standard Siebel Tools feature for this purpose. Querying the Foreign Key Table column is the documented, direct approach.