I have an application within which I maintain a dedicated table that effectively acts as a data dictionary with one row per database field.
I'm considering eliminating the table in favour of using the SQL database's own Extended Properties feature.
However, I'm not sure how, when I am manipulating a particular field using VB and ADO, I might access the extended properties for the individual field.
Can anyone shed any light please? Is there a way I can do it with ADO or would I have to execute a separate query to return a field's extended properties. I can access the field's "standard" properties using ADO field's Properties collection. I guess I'm wondering if there's something similar for extended properties.
I'm considering eliminating the table in favour of using the SQL database's own Extended Properties feature.
However, I'm not sure how, when I am manipulating a particular field using VB and ADO, I might access the extended properties for the individual field.
Can anyone shed any light please? Is there a way I can do it with ADO or would I have to execute a separate query to return a field's extended properties. I can access the field's "standard" properties using ADO field's Properties collection. I guess I'm wondering if there's something similar for extended properties.