October 25, 2004 at 11:43 am
SQL 2K - using the Enterprise Manager - Graphical User Interface - define a column in a table right click on the table name ... etc ... now I have figured out where in syscomments etc.
I can retrieve the column name, data type, length, allow nulls, is identity column, default values
BUT have NOT BEEN ABLE TO LOCATE WHERE THE 'DESCRIPTION' that the user may enter is STORED.
Any help would be appreciated.
October 25, 2004 at 11:50 am
It's part of the extended properties.
http://www.microsoft.com/sql/techinfo/tips/administration/extendedproperties.asp
October 25, 2004 at 1:47 pm
Thanks for the quick response will follow up with the MS site and the articles it also suggests for further reading.
October 26, 2004 at 4:32 am
Just as an FYI on storage. It is placed in the sysproperties table, the [name] field will read "MS_Description" and the ID is the objects id. So if you have a table named TestTable and wanted to look at the stored values in sysproperties you can do
SELECT * FROM sysproperties WHERE [id] = object_name('TestTable') and [name] = 'MS_Description'
However this is no the officially supported method and could change in future SQL versions.
October 26, 2004 at 8:40 pm
Steve Jones, Many thanks the info was all I required .. and besides being a big technical help the articles were an interesting read ... again thank you
Am using the information to write a custom application to print Schema and meta data out for any SQL 2K database for other programmers to use to make their work life just a little easier. Now if I could only cram all that information onto a 81/2 x 11 page with neatness and professional looking finished product.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply