Re: Finding data type for a column

From: Bruce Douglas <bruce.douglas_at_bridge.bst.bls.com>
Date: 1996/10/24
Message-ID: <326F7AD1.1266_at_bridge.bst.bls.com>#1/1

> > 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
 

>
>
> Look at the ALL_TAB_COLUMNS or USER_TAB_COLUMNS data dictionary views for the
> definition of all the table columns.
>

At the ODBC level, look at one of these functions: SQLColumns, SQLColAttribute, SQLDescribeCol

---

Bruce Douglas -- bruce.douglas_at_bridge.bst.bls.com BellSouth Telecommunications

---

Received on Thu Oct 24 1996 - 00:00:00 CEST