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

 Posted by Lakhangarg on 10/27/2009 | Category: Sql Server Interview questions | Views: 2224
Answer:

To Get Description of Columns we need to use system function sys.fn_listextendedproperty.

Command To Get Description Data for all Columns:

SELECT * FROM fn_listextendedproperty(NULL, 'SCHEMA',
'dbo', 'TABLE', 'YourTable Name Here', 'COLUMN', NULL)


Thanks & Regards
Lakhan Pal Garg


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response