Can we have more than two columns in Extended Properties using SQL Server 2008?

Question

I found that there are only two columns currently available on extended properties.

I would like to create more than two columns in the extended properties using SQL Server 2008.

I would like to make into more than two columns on that.

If any one come across this issue and has any suggestions, please let me know about that.

Thanks,

Vengat

Answer 1

Can you be more specific?  Generally speaking different extended properties would be stored in different rows. If you want to display them as > 1 column, you can simply pivot the values, which I will give an example of if that is what  you are looking for..

---

Louis

Answer 2

Hi Louis,

Thanks for your response and please find some additional information as your requested below:

When I am trying to create two columns in a table level by rightclick on the table and selecting the properties. Here, we have Table Properties window for extended properties. When I am going to extended properties, I got only two columns such as Name and Value. Actually, I would like to make one or more columns on this extended properties.

I have a scenario like lot of tables got various status code, status name, status type information etc and I would like to avoid by creating multiple looks tables. Instead of that, I am trying to use the features from extended properties from Table level and to create more than two columns.

I think, this information would be useful for my clarification. Please let me know if I am missing any thing for your clarification.

Thanks,

Vengat