locked
Extended Properties RRS feed

  • Question

  • I am having some wierd behavior that I can't seem to correct regarding exteneded properties. Via a T-SQL statement, I have added several exteneded properties to a table, for example:

    exec sp_addextendedproperty N'AP121ID', @value = 'AP121 Primary Key',
    @level0type = N'Schema', @level0name = dbo,
    @level1type = N'Table', @level1name=ap121,
    @level2type = N'Column', @level2name=AP121ID;
    GO

    This statement runs successfully. I can even query the sys.extended_properties table and see the entries.

    However, if i look at the properties of teh table to which I added the exteneded properties, they are not listed. Nor does it allow me to add one via that properties page.

    Any ideas?

    Thanks...

    Scott
    Friday, October 6, 2006 3:42 AM

Answers

  • Looks like you are adding extended properties to the column of the table and not the table itself.

    Can you check for extended properties on the table column via the properties page ?

    Friday, October 6, 2006 3:02 PM

All replies

  • Looks like you are adding extended properties to the column of the table and not the table itself.

    Can you check for extended properties on the table column via the properties page ?

    Friday, October 6, 2006 3:02 PM
  • Ah, yep, that was it.  Thanks!
    Monday, October 9, 2006 2:18 PM