1 Reply Latest reply on Feb 25, 2019 11:44 AM by Philip Stoyanov-Oracle

    Can we change sp_addextendedproperty to use sp_updateextendedproperty

    RRAJ

      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.