IDENTITY now supported in Azure SQL Data Warehouse
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:
- DBCC CHECK_IDENT()
See the IDENTITY documentation page for more information.