On Sat, May 22, 2010 at 3:13 PM, Greg Keogh <g...@mira.net> wrote: > Folks, the SQL Server Compact documentation does not hint that it is > possible to add metadata comments to a table during a CREATE. However, when > you run: > > SELECT * FROM INFORMATION_SCHEMA.TABLES; > > You can see a DESCRIPTION column. Is there are reliable way of putting > something in that column that isn’t obvious?
I don't see it on my regular sql servers here, but I expect you're referring to the 'description' extended property which can be manipulated with the 'sp_addextendedproperty' procedure (not sure if it exists in sql ce though ...) http://databases.aspfaq.com/schema-tutorials/schema-how-do-i-show-the-description-property-of-a-column.html > I ask because my utility app would like to display this information to be > nice to the user. > > Greg -- silky http://www.programmingbranch.com/
