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