Forums / General Questions / What is the difference between Drop and Empty table?

What is the difference between Drop and Empty table?

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

14 Apr 2007, 8:25 AM

dealbyethan_com

Totally Zenned

Join Date:: Dec 2005
Location:: Perth, Western Australia, Australia
Posts:: 782
Plugin Contributions:: 0

What is the difference between Drop and Empty table?

Hi,

Does anyone know what the difference between Drop and Empty table is?

14 Apr 2007, 8:34 AM

chuckl

Totally Zenned

Join Date:: Nov 2006
Location:: Papworth, Cambridgeshire, UK
Posts:: 717
Plugin Contributions:: 0

Re: What is the difference between Drop and Empty table?

Drop table removes the table from the database, usually to replace it with an updated table configuration in a subsequent create table statement. Empty table removes all information from the table, but leaves the table itself intact.