DDL Commands in SQL SERVER : DROP

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.

This entry was posted in . Bookmark the permalink.

Leave a reply