Re: Finding data type for a column

From: Matt Marrow [LOGICA][dc] <mmarrow_at_diana>
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)
 

: sp_helptext sp_help
 

: --
 

: 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

Original text of this message