sql - What sys.sp_addextendedproperty doing? -
i deleteing 1 month data table tbl_testrecord (diagrev 1 of colume )in test database .and going same in production database. when comparing script of same table in test database , production database, can see code in test database , not in production
exec sys.sp_addextendedproperty @name=n'ms_descriptionn', @value=n'diagrev' , @level0type=n'schema',@level0name=n'dbo', @level1type=n'table',@level1name=n'tbl_testrecord', @level2type=n'column',@level2name=n'diagrev'
what addextendedproperty sp doing? going crash delete script?
please advice !!
Comments
Post a Comment