access column

hi,

how can i access column name from SQL using query??

Thanks in advance

If the logged on user has the proper rights then you can use the following query:

-- for selecting the column names of the orders -- table in Northwind databaseselect [name]fromsyscolumnswhere id =object_id('orders')

|||

Thanks fren,it works

|||

Not at all, we are here to help eac other