Re: Finding data type for a column
From: mdchachi <mdchachi_at_ml.com>
Date: 1996/10/24
Message-ID: <326EBDA8.734D_at_ml.com>#1/1
Date: 1996/10/24
Message-ID: <326EBDA8.734D_at_ml.com>#1/1
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
use master (or sybsystemprocs)
-- use the same code that Sybase uses to do this which is found in the sp_help procedure. MikeReceived on Thu Oct 24 1996 - 00:00:00 CEST