CODEWITHSUNDEEP
visual-studio-2013sql-server-2014
Metaphor
Metaphor

Reputation: 6415

How to set extended properties in SQL Server database projects

Is there any way of setting the MS_Description extended property on objects in the SQL Server Database project in Visual Studio 2013?

Alternatively, is there a way to have extended properties created externally to the project persist in a SQL Server database project and thereby in source control?

Upvotes: 3

Views: 3057

Answers (2)

Orlando Colamatteo
Orlando Colamatteo

Reputation: 177

You can simply add a Script to you Project (right-click Project > Add.. > Script (Include In Build) ) and the DAC will take care of the rest.

Upvotes: 0

papadi
papadi

Reputation: 1105

The SQL table editor consists of a... table above, where you can put your column definitions and the generated SQL code bellow. If you right click on the column headers of the top table, you will see that there are additional hidden columns that you can show. One of them is actuall the Description that you are looking for!

As you can see, it makes use of sp_addextendedproperty stored procedure to update the MS_Description extended property.

Upvotes: 8

Related Questions