var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Fetching column names
Sorry if it is an already-answered post, but I've searched and never found it.
My question is: Is there a way of fetching column names of a specific table instead of their actual values?
Table A has 3 Columns: Column_Ex_No, Column_Ex_OK1, Column_Ex_OK2
Each column has their respective values, of course, but they don't matter to me.
I wanna know if there is a way of fetching only Column_Ex_OK1, Column_Ex_OK2 as VALUES from Table A, for instance.
Thank you in advance.
Try something like:
from sysobjects o, syscolumns c
where o.type = "U"
and o.name = "TableA"
and c.id = o.id
Thanks a lot! It works perfectly!