Thankyou - this is exactly the answer I have been looking for!!

Thankyou again.

I have come across an intersting situation...

::fn_listextendedproperty is now working, however I can only get the information for one table at a time.

select objname, value

from ::fn_listextendedproperty(NULL,'user','dbo','table','tblCMPCompany','column',default)

returns the column name...

Hi,

Thankyou for the replies.

Last time I generated the SQL script I didn't scroll down far enough to see the descriptions.

Also, Andy - I had looked at sysproperties previously, however wasn't...