How should delete the INDEX from Table?

Amollondhe007 · Post by **Amollondhe007** » Fri Jul 31, 2009 8:21 pm

Hi,

I had one question in interview.
How should you delete the the particular INDEX from Table if you have 4 INDEX assigned in a table?

Also how many max indexes should be in one Table?

Natarajan · Post by **Natarajan** » Fri Jul 31, 2009 10:28 pm

Refer following mainframegurukul tutorial on db2 sql for DROP command.
using DB2 DROP you can drop index.

http://www.geocities.com/srcsinc/databa ... IAL_2.html

Amollondhe007 · Post by **Amollondhe007** » Mon Aug 03, 2009 3:34 pm

Thanks. Natarajan.

Also i'm expecting how many max indexes should be in one Table?

Anand_Hakke · Post by **Anand_Hakke** » Thu Aug 13, 2009 2:24 pm

Maximum number of indexes per table is restricted to 15.

Regards,
Anand.

mainframegurukul.com

How should delete the INDEX from Table?

How should delete the INDEX from Table?

DB2 SQL DROP command

FREE TUTORIALS