Table information script

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