[SQL] checking if a column exists in a table

[Tsjipmanz]

Hi!

I'm busy programming a Cold Fusion webpage and now I have to know whether there is a SQLmethod to check whether a column exisits in a table.
I know the stucture of the table myself, but for sortingparameters it might come out handy to check if it's indeed a column which can be sorted with.

TIA

Tsjipmanz

 

[MikeJones]

What's the backend? If it's Oracle then you could do

select 1
from user_tab_columns
where table_name = &Table_Name
and column_name = &Column_name;

Mike.

 

[THoey]

Just in case you have multiple instances of the same database, just with different owners, you can add to Mike's perfect solution like so:

select 1
from user_tab_columns
where table_name = &Table_Name
and column_name = &Column_name
and owner = &Owner_Name;

Good call Mike... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.