1.4.4.7 Dropping Tables

Warning: Dropping a table in SQL means removing the table from the database and therefore losing all the data it contained.

To drop (or remove) a table in SQL you would use the following command:

DROP TABLE table_name

For example:

DROP TABLE Person

To drop the table above using a web.database cursor we would use the following code:

cursor.drop('Person')

The drop() method of a web.database cursor looks like this:

drop( table [, autoExecute]): table should be the table name as a string. autoExecute is optional and can be True or False. If set to True the command will be executed if set to False the sql command will be returned as a string. If not specified it takes the value of the cursor object.

See About this document... for information on suggesting changes.