Setting column extended properties in Azure DW

• btio_3000

  SSCrazy

  Points: 2662

  More actions

  November 30, 2017 at 4:03 pm

  #341903

  Hi,

  Though sys.extended_properties does exist in Azure DW, running
  EXEC sp_addextendedproperty
  returns an error of "Stored procedure sp_addextendedproperty does not exist or is not supported."

  Is there still a way to add/modify an extended property for a column in there?

  totally new to Azure DW, thanks in advance

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  December 1, 2017 at 4:29 am

  #1970236

  No. According to the documentation, that won't work with Azure SQL Data Warehouse. It also doesn't work with APS.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• btio_3000

  SSCrazy

  Points: 2662

  More actions

  December 1, 2017 at 10:25 am

  #1970326

  Thank you.

  so no way to do extended properties in Azure DW whatsoever?

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  December 1, 2017 at 10:52 am

  #1970331

  btio_3000 - Friday, December 1, 2017 10:25 AM

  Thank you.

  so no way to do extended properties in Azure DW whatsoever?

  Not at this time. It's just not supported yet. Kind of makes sense. There's not a table there, it's 60 tables behind the scenes. They just haven't gotten around to making that happen yet.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• btio_3000

  SSCrazy

  Points: 2662

  More actions

  December 1, 2017 at 11:13 am

  #1970338

  Bummer

  Thanks!