Q&A
Ask and answer questions to make information more available to wider audiences.
Nathaniel Kite
@kitenathaniel 19, Jul 2023 12:00 AM
delete a table in MariaDB's database
How to delete a table in MariaDB's database?
answers 2
Answer 1
Aiden Barti
@aidenbarti 09, Aug 2023 02:36 PM
If any of the tables named in the argument list do not exist, MariaDB returns an error indicating by name which not existing tables it was not unable to drop, but it also drops all of the tables in the list that does exist.
Syntax:
DROP TABLE table_name ;
Answer 2
Aiden Barti
@aidenbarti 09, Aug 2023 02:36 PM
DROP TABLE command is used to delete a table from a database in MariaDB. It deletes the table permanently and cannot be recovered. You must have DROP privilege for each table. All table data and the table definitions are removed, as well as triggers associated with the table so very careful with this statement!