SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we change sp_addextendedproperty to use sp_updateextendedproperty

RRAJFeb 20 2019 — edited Feb 25 2019

Can we use sp_updateextendedproperty() instead of sp_addextendedproperty to update column comments in generated DDL for SQL Server 2012+?

Alternatively, can we change it to a combination of:

sp_addextendedproperty (Transact-SQL)

sp_dropextendedproperty (Transact-SQL)

Please advise.

Added on Feb 20 2019

1 comment

314 views