DB2 graphic  QMF Version 8

Deleting tables, views, synonyms, and aliases

You can use either the QMF ERASE command or the SQL DROP statement to erase tables, views, synonyms, and aliases from the database.

For example, to use the QMF ERASE command to delete the CALENDAR table, enter:

ERASE TABLE CALENDAR

To use the SQL DROP statement to erase the same table, run this query:

DROP TABLE CALENDAR

When you use either the DROP statement or the ERASE command to delete a table from the database, any views or synonyms you created from them are also dropped.

To erase a table, you must be the owner of the table or have DBADM authority.

To erase a view or an alias, you must be the owner or have SYSADM or SYSCTRL authority.

To erase a synonym, you must be the owner of the synonym.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004