Is there a way in t-sql to check for the existence of an extended property on a field? (We are trying to setup a Data Dicitonary using extended properties. There is a problem. Suppose we setup 13 properties on a field. A month later we want to programmatically update or add a new extended property to the same field using our updated script. For update we need to check if the property already exists; otherwise, we will duplicate the Name! If the property does not exists then we "add" it.)
TIA,
Barkingdog