Pages

Thursday, November 1, 2012

How to select description of a column in SQL Server



If a Column in data base table contains description about that column.

then select statement is like this
syntax:

Select objname,Name,value from ::fn_listextendedproperty('MS_Description','user','dbo-name','table','table-name','column',column-name').