Question : Why can a SQL Server table not have more than one identity column? CREATE TABLE t(id INT IDENTITY, […]
Tag: identity
How to increment identity without add a row and get the skipped value?
Question : I’m trying to preserve value in identity column in manner to be added later. The value should be […]
Merge Replication identity field issues
Question : One of our clients is using our software with merge replication of a database on a SQL Server […]
Can I implement a ‘gapless’ identity column in Oracle?
Question : In SQL Server it is so easy to write: create table #tmp ( id integer identity(1,1) primary key, […]
How can I change an existing type from “bigint” to “bigserial”?
Question : I have a PostgreSQL table with the following structure: I simply need to change the TYPE of prove_identity_id […]
Can IDENTITY COLUMNS generate UUIDs?
Question : I’m just wondering if either the spec of the implementation (PostgreSQL) provides for generating identity columns from UUIds […]
Why can’t PostgreSQL identity columns be used in CREATE TYPE?
Question : My impression is that each PostgreSQL table has a corresponding composite type associated with it. But it seems […]
What could cause the wrong ID to be inserted?
Question : I have a SQL Server 2008 server (build 10.0.5500). Earlier this week I ran this on a table […]
What could cause an auto increment primary key to skip numbers? [duplicate]
Question : This question already has answers here: Unexpected gaps in IDENTITY column (2 answers) Closed 6 years ago. I […]
Configured identity seed starting value on database level
Question : Is there an option in sql server to configure the default starting value(seed) of an identity column on […]