Post reply

sp_addextendedproperty

  • July 15, 2013 at 12:38 am

    #279907

    Hi All,

    I came across "sp_addextendedproperty" in Adventureworks2008R2 .

    EXEC sys.sp_addextendedproperty @name=N'MS_Description',

    @value=N'Primary key for ContactType records.' ,

    @level0type=N'SCHEMA',@level0name=N'Person',

    @level1type=N'TABLE',@level1name=N'ContactType',

    @level2type=N'COLUMN',@level2name=N'ContactTypeID'

    GO

    Can someone help me explaining the use of this sp..Where and when do you use it..If possible can you please explain me with someother example..

  • July 15, 2013 at 3:08 am

    #1632365

    It is for adding metadata to a database or objects within a database. Can be used for documentation of a database that stays with the database no matter where installed.

    sp_addextendedproperty (Transact-SQL)

    Joie Andrew
    "Since 1982"

  • August 21, 2013 at 10:52 am

    #1643538

    Pessoal segue dica de ferramenta para gerar dicionário de dados formato Excel.

    http://gpsenior.blogspot.com/2013/08/gerador-de-dicionario-de-dados-em-excel.html

  • August 21, 2013 at 7:17 pm

    #1643724

    I've used it for databases, for ex - with details as to its purpose, sometimes the restore information - which date, backup, etc

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply