Boyd564852


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

dbname

- Tables

- dbo.xyz

-Columns

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

/Boyd




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.

---
http://www.sqlserver2005.de
---





Re: table column extended field properties

Boyd

Hi,

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

Regards

Boyd