Identity column to be used in referential integrity

NitheshNithesh - Select Field - ✭
in General Discussion

I am migrating data from MySQL to Vertica.

ID(Auto Increment)key in one table is referenced as the foreign key by another table. This FK implementation is on multiple tables in MySQL and is intrinsic to the functionality.

Vertica doesnt allow FK referencing on an Identity column,simply creating a ID key with int datatype wont work as the column has to be autoincrementing, how would i go about resolving this?

 

Comments

  • PraveshPravesh

    Hi Nithesh,

     

    Can you give some example of your problem?

     

    Identity columns can be used as primary keys, and they can be referred by foreign key in another tables.

     

     

     

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...