IDENTITY now supported in Azure SQL Data Warehouse

26 June 2017

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.

Free account

Get $200 in Azure credit and 12 months of popular services – free

Start for free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Start-ups

Join the BizSpark programme and get free Azure services

Learn more