Home Dashboard Directory Help
Search

Add full extented property support to SSDT by Mark Freeman


Status: 

Closed
 as Won't Fix Help for as Won't Fix


2
0
Sign in
to vote
Type: Suggestion
ID: 779313
Opened: 2/15/2013 9:56:22 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.

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

>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?

Thanks,
Mark
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
Sign in to post a workaround.