SQL DROP Statement
SQL DROP statement is used to completely delete the object from the database or you can drop database itself. You can use DROP statement to delete tables, indexes, views, procedures, users, databases etc.
DROP TABLE Statement
The DROP TABLE statement is used to delete or remove table from database. Once DROP table is executed then it will remove all data, table definitions, constraints, indexes and related triggers etc.
DROP TABLE TableName
Let’s drop table tblPassStudents from database.
DROP TABLE tblPassStudents
Once table is dropped and if you will query that table then it will show you error message as ‘Invalid object name ‘tblPassStudents”
DROP PROCEDURE Statement
The DROP PROCEDURE is used to remove one or more stored procedures from database.
DROP PROCEDURE ProcedureName
Or you can also drop multiple procedures.
DROP PROCEDURE Procedure1, Procedure2, …, ProcedureN
You can use DROP PROC also instead of writing whole word.
DROP DATABASE Statement
The DROP DATABASE statement is used to remove a database from SQL Server instance.
DROP DATABASE DatabaseName
Reference: Manzoor Siddiqui [www.SQLServerLog.com]