What is an 'Identity Column'?

What is an 'Identity Column'?

Approach: Describe auto-incrementing values.

A column in a database table that automatically generates a unique numeric value for each new row, typically used as a primary key.

Follow-up: Can you manually insert a value into an identity column?

Key concepts: surrogate key, primary key.