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

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

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

Postby joeriks » Tue Nov 12, 2013 12:27 pm

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.
joeriks
 
Posts: 3
Joined: Tue Nov 12, 2013 12:22 pm
Location: Sverige

Postby eugenen » Tue Nov 12, 2013 12:34 pm

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
eugenen
 
Posts: 5
Joined: Tue Feb 23, 2010 11:13 am

Re:

Postby joeriks » Tue Nov 12, 2013 12:43 pm

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?
joeriks
 
Posts: 3
Joined: Tue Nov 12, 2013 12:22 pm
Location: Sverige


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 1 guest