Add full extented property support to SSDT - by Mark Freeman

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 779313 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/15/2013 9:56:22 AM
Access Restriction Public


I can go into SSMS 2012, right-click on a table, select Properties, select the Extended Properties page, and then enter names and values. However, if I go into VS 2010 with SSDT (December 2012 version), right-click on a table, select Proprerties, and there is no mention of Extended Properties. I can't view, add, edit, or delete them.

I would like to see full support for extended properties on databases, schemas, tables, table columns, view, and view columns. 

Sign in to post a comment.
Posted by Mark Freeman on 2/22/2013 at 6:27 AM

>defining extended properties are fully supported in SSDT and DACFx including project build, and deployment

Where can I find the documentation on the existing SSDT support for extended properties? I don't see any obvious way through the SSDT UI to create one on any object type. Or do I have to create them in the database manually or through SSMS and the import them via a database to project Schema Comparison?

Posted by Microsoft on 2/21/2013 at 6:27 PM
Hey Mark,

Thanks for your feedback around design-time Extended Property support in SSDT. At this time, the team is not pursuing the addition of an extended property designer. One thing to make sure folks understand is that defining extended properties are fully supported in SSDT and DACFx including project build, and deployment.

Thanks and let us know if you have any additional feedback or questions!
Adam Mahood
Program Manager
SQL Server Database Systems