In the page, use the extended properties of SQL Server to display comments for columns as access

The Design view of access has a good feature-----design column annotations, which allows the designer to see clearly the meaning of each column. The general SQL Server does not have this function when building a table, but he has extended properties, this function is also good, you can write the comments here, and then the corresponding results as RS back to the page to apply
I think it might be useful to dynamically display the column information of a table in a database (remember as if someone in the Forum had asked before)
The specific method is as follows: (can also be added in Em,qa by right-clicking the corresponding column---extended property)
EXEC sp_addextendedproperty ' crid ', ' Expression id ', ' user ', dbo, ' table ', ' clientinfo ', ' column ', Crid
Go
EXEC sp_addextendedproperty ' names ', ' Show customer names ', ' user ', dbo, ' table ', ' clientinfo ', ' column ', rname
Go
Select Name,value from:: Fn_listextendedproperty
(default, ' user ', ' dbo ', ' table ', ' clientinfo ', ' column ', default)
Go
Name value
---------------------------------------------
Crid Representation ID
People's names show customer names
So you can use it as a result set.
Here it is. System multi-table value function Fn_listextendedpeoperty simply say
Query, because it is a system multiple table value function, so the front must have::
The 1th is to specify the property name----If all is displayed with default or null
第2-7个 parameters, you can see SQL's object naming rules
If default is also specified in all
More Information View Bol