DROP Commands

From Lianjapedia
Revision as of 04:33, 4 August 2016 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.