Re: Pulling Column information from a table

From: Dave <x_at_x.com>
Date: Fri, 05 Nov 2004 19:33:01 GMT
Message-ID: <NzQid.35731$Bk6.7966@fe2.news.blueyonder.co.uk>

"Peter" <peter_at_mclinn.com> wrote in message news:dcde2a5a.0411051125.4d116dc8_at_posting.google.com...
> Is there a way to run a sql statement against oracle 9i to pull out
> the column names and primary key information from a specific table?

take a look at user_tab_columns and user_constraints Received on Fri Nov 05 2004 - 13:33:01 CST

This message: [ Message body ]
Next message: Joel Garry: "Re: UncleOra for Oracle - tool with a script library and an advanced grid for developers and DBAs"
Previous message: Jonathan Lewis: "Re: Default optimizer_index_caching value DUMB ..."
In reply to: Peter: "Pulling Column information from a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US