add/modify Multiple Extended Properties

Tell us what features you'll want
Post Reply
fxerkan
Posts: 8
Joined: Mon Nov 12, 2018 10:18 am

add/modify Multiple Extended Properties

Post by fxerkan » Tue Dec 04, 2018 9:29 am

Normaly we have a Description for the table(s) or column(s) and this forwarded to SQL Database as an extended property like ( 'MS_Description' )

but SQL server has capability to adding/managing multiple and customized Extended Properties for each entity like below;
https://www.mssqltips.com/sqlservertip/5384/working-with-sql-server-extended-properties/
https://support.erwin.com/hc/en-us/articles/115000877452-How-to-create-script-with-User-Defined-Extended-properties-for-SQL-Server-tables-and-columns-
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38628.1600/doc/html/rad1232022416747.html

we need to add multiple extended properties for each entity like below and manage them from the DbSchema.
* Author, Reviwer, Compliance, .... etc.

Can you please add a Extended Property/Attribute Designer screen?

Post Reply