Skip to main content

Imported through SQL server and pasting the results from the query provided. I can clearly see that my table defines a PK and FK but on the table I do not see the FK listed.

 

Data generated:

dbms    TABLE_CATALOG    TABLE_SCHEMA    TABLE_NAME    COLUMN_NAME    ORDINAL_POSITION    DATA_TYPE    CHARACTER_MAXIMUM_LENGTH    CONSTRAINT_TYPE    TABLE_SCHEMA    TABLE_NAME    COLUMN_NAME
sqlserver    LogosDB    dbo    PMCentralServiceAddress    PMCentralServiceAddressID    1    int    NULL    PRIMARY KEY    NULL    NULL    NULL
sqlserver    LogosDB    dbo    PMCentralServiceAddress    AddressID    2    int    NULL    FOREIGN KEY    dbo    AddressComponents    AddressID
sqlserver    LogosDB    dbo    PMCentralServiceAddress    ServiceCarrierRoute    3    varchar    4    NULL    NULL    NULL    NULL
sqlserver    LogosDB    dbo    PMCentralServiceAddress    DeliveryPoint    4    int    NULL    NULL    NULL    NULL    NULL
sqlserver    LogosDB    dbo    PMCentralServiceAddress    ChangedUserID    5    int    NULL    NULL    NULL    NULL    NULL
sqlserver    LogosDB    dbo    PMCentralServiceAddress    ChangedDate    6    datetime    NULL    NULL    NULL    NULL    NULL
sqlserver    LogosDB    dbo    PMCentralServiceAddress    ParcelNumber    7    varchar    32    NULL    NULL    NULL    NULL

 

0_0?a=4033&x=14&y=-1556&w=542&h=331&store=1&accept=image%2F*&auth=LCA%209d896e41ed0f399791486e797da2d0ee9831fe748c0bc7ec973c8ffe5d4ec6d1-ts%3D1733774930

Hi ​@VincentVAN ! 

Thank you for posting in the Lucid Community, I’m happy to help! 

Would you mind re-uploading your results to Lucid in a private or incognito window to help us narrow down the potential cause? Could you also try connecting to a different network or disconnecting from your VPN (if applicable)? Sometimes account performance issues can be related to internet security/speed or browser issues. These steps will help us eliminate that possibility. For help with opening an incognito window, please see this community post (in English).

To clarify- the FK you are expecting to see is AddressID? 

Thank you! Hope this helps! 


Hey ​@Hannah ,

 

Thanks for the response. I tried importing the data set again using the tImport Data]  - ERD

Pasted my results from the query provided: (You can see in the output of plain text that the Foreign Key is designated.)

Still don’t see the Foreign Key get designated on the diagram:

 


Reply