Never mind... I wasn't setting the identity to a specific data type... What is the default data type if one isn't set?
I went ahead and used integer: ID INTEGER IDENTITY PRIMARY KEY On Feb 20, 2:46 pm, edwardsk <[email protected]> wrote: > If I have two tables A & B > > and (A) has a PK which is an Identity... > and (B) has a FK which points to it... > > what should the FK's datatype be? > VARCHAR works... will bigint work? > > From the documentation: > IDENTITY Possible values: -9223372036854775808 to 9223372036854775807. > BIGINT Possible values: -9223372036854775808 to > 9223372036854775807. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
