Re: Finding data type for a column
Date: 1996/10/24
Message-ID: <54o8q9$10s_at_zeus.mobile.com>#1/1
If it was an Oracle database, you could just try:
SELECT data_type
FROM all_tab_columns
WHERE table_name = 'STUDENTS'
AND columns_name = 'ADDRESS';
You can also use the same table to find out null restriction, sizing and so on.
Hope this helps
Matt
mmarrow_at_pacbell.mobile.com
mdchachi (mdchachi_at_ml.com) wrote:
: 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.
: Mike
Received on Thu Oct 24 1996 - 00:00:00 CEST