MySQL 테이블 삭제 DROP TABLE

(DROP TABLE에서 넘어옴)

1 개요[ | ]

MySQL DROP TABLE
  • 테이블을 삭제하는 MySQL 쿼리
MySQL
Copy
DROP TABLE 테이블명;

2 실행예시[ | ]

Console
Copy
mysql> SHOW TABLES;
+--------------------+
| Tables_in_mydb2016 |
+--------------------+
| dept               |
| posts              |
+--------------------+
2 rows in set (0.01 sec)
Console
Copy
mysql> DROP TABLE dept;
Query OK, 0 rows affected (0.00 sec)
Console
Copy
mysql> SHOW TABLES;
+--------------------+
| Tables_in_mydb2016 |
+--------------------+
| posts              |
+--------------------+
1 rows in set (0.00 sec)

3 같이 보기[ | ]

4 참고[ | ]