Getting the Column Description from SQL Server 2000

[Aarvee]

Hi !

In many of the cases, we wish to name the columns of the table in a specified way which is not the way we can present it to the user. Hence we do enter the description for each column which are user friendly.

I would like to ferret out this information from SQL Server 2000 through VB.Net so that I can use it for column headings in DataGrid.

Can someone tell me how to do this ?

Thanks a lot in advance.

Varadarajan R

 

[tchavez]

Why not just do this

Select columnA as Items, columnB as Prices, columnC as Descriptions From table

columnA, columnB,columC would be the names that you are currently using and Items,Prices,Descriptions would be the names you wish to use.

Hope that helps...

 

[Aarvee]

Thank you tchavez for the reply. I think perhaps I should explain the situation again.

In SQL Server 2000 when you design a table, there is a column for Description at the bottom with the default properties etc. These I have filled in the table. I would like to read those values and use that as the column headings when I use select statements.

Hope the situation is clearer now.

Thanks for your help.

Varadarajan R

 

[tchavez]

Not sure that you can read it. I think it maybe just a "Notes" for managing the tables.

 

[tchavez]

http://www.tek-tips.com/viewthread.cfm?qid=1166514&page=1

Not sure that will help but that is a small discussion on it I believe.

 

[Aarvee]

Resolved

Thanks for the guidance. It was useful and the solution found.

thanks once again.


Varadarajan R