SQL SERVER Tips and Tricks

DDL: Data Definition Language

DROP command used to drop the database objects in SQL Server.

Here are the example of DROP Command:

• DROP DATABASE:

Drop or remove a database with the name MYDB from the server.

DROP DATABASE MYDB

• DROP TABLE:

Drop or remove a table with the name MYTABLE from database.

DROP TABLE MYTABLE

• DROP PROCEDURE:

Drop or remove a stored procedure with the name MYSP from database.

DROP PROC MYSP

DROP PROCEDURE MYSP

• DROP FUNCTION:

Drop or remove a function with the name MYFUNC from database

DROP FUNCTION MYFUNC

• DROP TRIGGER:

Drop or remove a Trigger with the name MYTGR from database

DROP TRGIGGER MYTGR

Summary:

Drop is DDL command, which will remove database objects from server.