Re: Finding data type for a column

Jedi wrote:
>
> Hi,
> I am trying to find out the data type of an column from within my
> applicaton.
> What is the ODBC or SQL statment to do that? For example, I have a table
> called
> Students and I want to know what data type the column name Address
> belongs to.
>
> Thanks in advance for any suggestions or comments
>
> Dennis
>
> ------------------------------------------------------------------
> Georgia Institute of Technology
> School of Electrical Engineering, Atlanta, GA 30332-0250
> E-MAIL: jedi_at_eecom.gatech.edu

Can't you just use "desc students" to get a listing of all the columns with their data types? I'm just starting out in this stuff but it seems simple enough to me.

-- 
####################################################################
Bob Woodward, Seattle FilmWorks     (bobw_at_filmworks.com)
Data Processing Department

Visit our Web Site to learn how to get your pictures downloaded to you
via the Internet!  Point your browser to "http://www.filmworks.com".