In SQL we use ALT+F1 to get the properties of the table or a SP, we also know about the primary and foreign key information. How do we do this in Oracle. I have a table name, but i am not able to get it properties in Oracle. I m not sure whether it a table or SP. I also want to know in which database it resides and what is its Schema Kindly help me out.

Since this forum is for SQL Server related discussions, I doubt your queries for Oracle gets the due response here. Pradeep Adiga Blog: sqldbadiaries.com

You might find some joy here: http://dbaspot.com/forums/database-discussions/25817-what-oracle-equivalent-sybases-sp_help.htmlIf you find this helpful, please mark the post as helpful, If you think this solves the problem, please propose or mark it an an answer. Please provide details on your SQL Server environment such as version and edition, also DDL statements for tables when posting T-SQL issues Richard Douglas My Blog: Http://SQL.RichardDouglas.co.uk Twitter: @SQLRich