Doing DESC in Pro*C

From: Pauil Perkins <paulp_at_despam.penguinpowered.com>
Date: Sun, 11 Apr 1999 11:32:08 +0100
Message-ID: <7eptna$p76_at_romeo.logica.co.uk>



Hi All,

[Quoted] 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.

[Quoted] 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.

[Quoted] 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 Sun Apr 11 1999 - 12:32:08 CEST

Original text of this message