DROP Commands

From Lianjapedia
Jump to: navigation, search
Command Description
DROP CURSOR Free up all system resources allocated to a cursor.
DROP DATABASE Remove the specified database and all its tables.
DROP INDEX Remove an index from a table.
DROP PROCEDURE Remove a stored procedure from a database.
DROP TABLE Remove a table/virtual table (and all its data) from a database.
DROP VIEW Free up all system resources allocated to a view.