Azure SQL Data Warehouse now supports the IDENTITY property for the creation of surrogate keys.
IDENTITY is supported in the following contexts:
- SELECT..INTO a table with pre-existing IDENTITY column
- SET IDENTITY_INSERT
- Loading data into tables with IDENTITY through PolyBase INSERT..SELECT or INSERT..VALUES and BCP
- sys.identity_columns DMV
The following are currently not supported:
- IDENTITY()
- @@IDENTITY
- SCOPE_IDENTITY
- IDENT_CURRENT
- IDENT_INCR
- IDENT_SEED
- DBCC CHECK_IDENT()
See the IDENTITY documentation page for more information.