|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
December 22nd, 2005, 05:12 AM
|
||||
|
||||
|
Script to drop all indices of a table
Hi, I am trying to drop all the indices of a table. How should I write my sql statement to drop all the indices built for the columns of a given table X ?
__________________
When the programming world turns decent, the real world will turn upside down. 
|
|
#2
December 22nd, 2005, 07:55 AM
|
||||
|
||||
|
Start from this script that lists all indexes for a given table
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Script to drop all indices of a table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
