How To Get Description Value for Single Column in Table using SQL Command?

Answer:

To Get Description of Single Column we need to use system function sys.fn_listextendedproperty. we need to pass the column Name is this case.

Command To Get Description Data for Single Columns:

SELECT * FROM   fn_listextendedproperty(NULL, 'SCHEMA',

 'dbo', 'TABLE', 'Table Name Here', 'COLUMN', 'Column Name Here')

Thanks & Regards
Lakhan Pal Garg