through MS SQL Server Management Studio I have a database defined as:


- Tables



Field definition_a

Field definition_b

Field definition_c


For each "Field definition" I can define "extended properties"

So the question is, from a stored procedure in C#, how can I read through the "Field definitions"

looking for an extended property of a specific integer value


Re: table column extended field properties

Jens K. Suessmeyer

I am fan of SQL Server SMO, so you could co with either the SMO stack to get the information, or use Select statements to extract the data. Do you have a prefered way

BTW, is the procedure written in C# That would narrow down the options.

Jens K. Suessmeyer.


Re: table column extended field properties



I am not familiar enough with the options to have a preference

Actually I don't know what the options are.

I'm trying to write in C# clr code, but whatever works.

also, What is smo