Entry

Database: Language: SQL: Table: Operation: Remove: How to delete a table completely? [drop]

May 22nd, 2005 02:06
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 20 March 2005 - 04:21 pm ----------------------

Database: Language: SQL: Table: Operation: Remove: How to delete a 
table completely? [drop]

---

Use the SQL command:

---

 DROP TABLE <your table name>

---

you can also use

 DROP TABLE IF EXISTS <your table name>

---
---

General format:

-----------------------------------------------
DROP TABLE
 <mytablename>
;
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
DROP TABLE IF EXISTS
 tableStudy
;
-----------------------------------------------

---
---

Internet: see also:

---

Database: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------