deleting tables

**Andrew-J2000** · Feb 27, 2002 09:39

How can I delete a table from a database?

thanks for any help

**DaveMaxwell** · Feb 27, 2002 10:04

Use the DROP Table command

**numeropi** · Feb 27, 2002 10:05

If you want to delete only the records but keep the table, then

Code:

DELETE FROM tablename;

else, if you really want to get rid of the table itself (along with all records),

Code:

DROP TABLE tablename;

Just make sure this is what you want before actually doing it

**hillsy** · Feb 27, 2002 10:08

DROP TABLE <Name>;

Be careful

<edit>
Oh man, how many other people can reply in the time it takes me to write "Drop Table"?

</edit>

**Andrew-J2000** · Feb 27, 2002 10:27

Hehe thanks for the help.

User Tag List