Between 5 and 30 characters. By clicking Join Now, you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Check if an index exists on a table. I am writing a code which has to create index when reading from a table but needs to drop an index when writing into it. Is there a way I can check if an index exists? (So if found I can delete it.) Thanks.
1. FAT. The traditional DOS filesystem types are FAT12 and FAT16. Here FAT stands for File Allocation Table: the disk is divided into clusters, the unit used by the file allocation, and the FAT describes which clusters are used by which files.
In addition, the file allocation tables must be stored in a fixed location so that the files needed to start the system can be correctly located. The file allocation table contains the following types of information about each cluster on the volume (see example below for FAT16): 1  Unused (0x0000). 2  Cluster in use by a file. 3  Bad cluster (0xFFF7). 4  Last cluster in a file (0xFFF8-0xFFFF).