Are there any other commonly used SQL commands?


#1

Question

In the context of this lesson, are there any other commonly used SQL commands?

Answer

The SQL commands covered in this lesson are probably the most common ones you will encounter or need to use when working with tables. Other available commands are more situational and not as commonly used.

One such command is DROP TABLE, which you can use to permanently remove a table from a database. Deleting tables is generally not a frequent occurrence, so you might only use this once in a while. Other commands, such as ANALYZE, which is used to obtain statistics about a table, are also not as common and you might only use them in certain situations.

For a full list of all the commands provided by SQLite, which is used in the Codecademy courses, you can check out the official documentation.