MySQL – Drop Index Table of content The DROP statement in MySQL database is used to remove or delete an existing database object such as a table, index, view, or procedure. Whenever we use DROP statement with any of the database objects, like indexes, it will remove them permanently along with their associated data. Therefore, […]

MySQL – Create Index Table of content A database index improves the speed of operations in a database table. They can be created on one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records. Practically, indexes are a special type of lookup tables, that hold a […]

MySQL – Drop View Table of content A MySQL View is a virtual table which is generated from a predefined SQL query. It contains (all or selective) records from one or more database tables. Views are not stored in a database physically, but they can still be dropped whenever not necessary. Even though they are […]