Top "Identity-column" questions

An Identity column is a column in a database table that is made up of values managed by the server and cannot be modified, to be used as a primary key for the table.

Identity Column as Primary Key

Could you please opine if having identity column as primary key is a good practise? For ORM tools, having identity …

primary-key identity-column
How do I set Identity seed on an ID column using Entity Framework 4 code first with SQL Compact 4?

I am having some problem setting the Identity Seed on the Id column in SQL Compact 4 using the code first …

entity-framework-4 ef-code-first sql-server-ce identity-column
Oracle identity column and insert into select

Oracle 12 introduced nice feature (which should have been there long ago btw!) - identity columns. So here's a script: CREATE …

oracle identity-column oracle12c
MySQL join 2 tables but rename columns because they have the same name

I have 2 tables, admin, pricing admin contains columns (id, date_created, type, value) pricing contains columns (id, date_created, relation, …

php mysql join identity-column
Reseed identity column to 0 fails - current identity value is NULL

I restore database and delete records in my_table using delete from my_table; Then I reseed table identity column …

sql sql-server-2008 identity-column
Teradata: How to back up a table that uses an identity column?

In Teradata, the way I've been doing backups for tables is like this: create table xxx_bak as xxx with …

sql backup teradata identity-column
How to reseed an an auto increment column in a SQLite database?

Is it possible to reseed an auto increment column in a SQLite database, and if so, how is this done? …

sql tsql sqlite identity-column