TL;DR – You can remove a database, a table or an index easily by using the DROP command.
Contents
The syntax for SQL DROP
In MS Access
Example
DROP INDEX indx_name ON tbl_name
In MS SQL Server
Example
DROP INDEX tbl_name.indx_name
In DB2/Oracle
Example
DROP INDEX indx_name
Pros Main Features
- Easy to use with a learn-by-doing approach
- Offers quality content
- Gamified in-browser coding experience
- The price matches the quality
- Suitable for learners ranging from beginner to advanced
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
Pros Main Features
- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid Certificates of completion
Pros Main Features
- A wide range of learning programs
- University-level courses
- Easy to navigate
- Verified certificates
- Free learning track available
- University-level courses
- Suitable for enterprises
- Verified certificates of completion
In MySQL
Example
ALTER TABLE tbl_name DROP INDEX indx_name
SQL DROP TABLE
Example
DROP TABLE tbl_name
SQL DROP DATABASE
Example
DROP DATABASE db_name
Removing the data from the table
Example
TRUNCATE TABLE tbl_name