Add comment/description to db objects (tables,views,sprocs)

joeriksjoeriks Posts: 4
edited November 12, 2013 6:43AM in SQL Prompt
Can I add a comment or description to db objects with the help of any of the Redgate tools? A comment that should be easy to find later, for example just by clicking / hovering the object, and be searchable.

In SQL Search there's a column "Detail" that might be "it". But where does the info for that come from?

I imagine a simple tool to expose some standardized Extended property some way.
· Share on Twitter

Comments

  • eugeneneugenen Posts: 6 Bronze 1
    You can use SQLDoc to do this or use the stored procs to manipulate the extended properties. SQL Prompt does display extended properties when you hover on columns/tables etc
    · Share on Twitter
  • joeriksjoeriks Posts: 4
    Ah, yea, just found the SQL doc nice feature to "edit" the MS_Description extended property. Very nice! But I do not get SQL Prompt to display extended properties when hovering?
    · Share on Twitter
Sign In or Register to comment.