The DROP statement is used to delete object in SQL, with the DROP statement we can remove index, tables and even databases easily.
DROP INDEX
The indexes of the table can be dropped by the using the following command.
SYNTAX for MS Access
The MID() function is used to extract values from a column. The MID() contain three (3) parameters. The first one is used to select which column to extract, the second one is the starting position, the last one is the number of characters to be extracted.
SQL MID() Syntax
