OraFAQ Forum: Forms » Sql doubt

Home » Developer & Programmer » Forms » Sql doubt

Thu, 12 August 2004 07:26

pratyusha_2004@rediffmail
Messages: 1
Registered: August 2004

Junior Member

How can we find whether an index is created on any column in a table other than primary key/unique key constraints.

Thu, 12 August 2004 20:26

Mahesh
Messages: 90
Registered: January 2001

Member

U can view all the indexes by running following query

select * from user_indexes where table_name=' ';
it will give all the indexes on that table.

Previous Topic:	doubt in forms 6i
Next Topic:	Weird problem with KEY-COMMIT

Goto Forum:

]

Current Time: Wed Aug 07 14:23:37 CDT 2024