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 TIA Sanjay __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com