How do I retrieve column names?

[Hurricane766]

Hi,
I'm wondering if there is a way to retrieve the names of columns from a table using sql?

Thanks

 

[PHV]

You have to know how your SQL dialect deals with the system catalogs.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hurricane766]

Thanks,
I found that this will work:
select Cname from syscolumns where Tname = <table_name>;