Today I discovered what extended property in sql server is useful for...<grinz>
it is for comments. When u create a table, u can add extended property for the columns as comments. Then you can use a tool to generate a data dictionary.
For details on extended property, please look "Using Extended Properties on Database Objects" in SQL Books Online.
Code Snippet of using extended properties:
USE AdventureWorks;
GO EXEC sys.sp_addextendedproperty @name = N'MS_DescriptionExample', @value = N'Minimum inventory quantity.', @level0type = N'SCHEMA', @level0name = Production, @level1type = N'TABLE', @level1name = Product, @level2type = N'COLUMN', @level2name = SafetyStockLevel;
Url for the tool to generate the data dictionary:
http://www.elsasoft.org/