Can the users not specify primary key when create a table in Berkeley DB 11gR2?
Yes, when you create a table in Berkeley DB 11gR2, you do not need to specify a primary key. In this case, Berkeley DB 11gR2 will create an implicit integer “row ID” column as the primary key, so if you specify a non-integer primary key, there will be a second table that maps the primary key to the row ID.
Yes, when you create a table in Berkeley DB 11gR2, you do not need to specify a primary key. In this case, Berkeley DB 11gR2 will create an implicit integer row ID column as the primary key, so if you specify a non-integer primary key, there will be a second table that maps the primary key to the row ID. There are two Berkeley DB tables in that case: • the primary table containing the complete row, with integer keys (row IDs) that are managed by SQLite; • the index that maps application key -> row ID.
Related Questions
- How do I specify which key to use when an individual has 2 or public keys and the very same user ID on each, or when 2 different users have the same name?
- I have a table partitioned on column timestamp, with a primary key on column id. How do I create a locally partitioned index for this PK ?
- Id like to create a Key Survey account for multiple users. What are my options?
