Doing "DESC" in Pro*C

From: Pauil Perkins <paulp_at_despam.penguinpowered.com>
Date: Fri, 9 Apr 1999 12:36:06 +0100
Message-ID: <7eplio$mc3@romeo.logica.co.uk>

Hi All,

Is there a way to perform a "DESC" on a table using Pro*C. I want to enumerate the column names and types for a particular table using Pro*C at runtime.

I've seen that you can do a DESCRIBE on a prepared DSQL statement, but this (I think) enumerates the types of the columns contained in the statement - i.e. requires prior knowledge of the table.

I'm trying to write a tool that sniffs out the available tables and displays the available columns along with column types.

Any ideas?

Thanks,

Paul. Received on Fri Apr 09 1999 - 06:36:06 CDT