Table information script

From: Sanjay Mishra <>
Date: Thu, 13 Aug 2009 18:57:27 -0700 (PDT)
Message-ID: <>

Can somebody share the query that can give the table information with Primary and Foregin Key as shown in tools like Toad or as shown below

Owner   TableName   ColumnName   DataType    Null/NotNull        PrimaryKey(Y/N)   Foreign Key(Y/N)   ParentTable


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
Received on Thu Aug 13 2009 - 20:57:27 CDT

Original text of this message