On this page

DROP TABLE

Updated on 2022-11-18 GMT+08:00

Syntax

DROP TABLE [ IF EXISTS ] table_name

Description

This statement is used to drop an existing table. If the optional parameter IF EXISTS is specified and the table to be deleted does not exist, no error is reported.

Example

create table testfordrop(name varchar);
drop table if exists testfordrop;
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback