CODEWITHSUNDEEP
sqlsql-server-2008system-stored-procedures
sony921
sony921

Reputation: 117

What sys.sp_addextendedproperty doing?

I am deleteing one month data from table tbl_testrecord (diagrev is one of the colume )in test database now .And i will going to do same in Production database. When i am comparing script of the same table in test database and production database, I can see this code in test database and 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 exactly this addextendedproperty SP doing? is it going to crash my delete script?
Please advice !!

Upvotes: 0

Views: 997

Answers (0)

Related Questions