sp_help <table name>
will get all the information about the table such as foreign keys..
is there any way we can get table information in oracle9i

table information :
describe <TABLE_NAME>

foreign keys...try this :

select
ucA.Table_Name TABLE_PARENT,ucA.Constraint_Name,decode(ucA.Constr aint_Type, 'P', 'PRIMARY KEY', ucA.Constraint_Type ) Constraint_Type,
ucB.Table_Name TABLE_CHILD,ucB.Constraint_Name,decode(ucB.Constra int_Type, 'R', 'FOREIGN KEY', ucB.Constraint_Type ) Constraint_Type
from user_constraints ucA, user_constraints ucB
where ucB.r_Constraint_Name=ucA.Constraint_Name

yes i tried executing the statement desc <tablename> in toad it got me all the required information of table
but when i run the same query via asp.net application it gives me error:Invalid Sql statement
can anybody help me

Select * from user_constraints where table_name=mytab;
mytab= name of ur table

maybe DBMS_METADATA will help you