DDL: Drop Statements

Table

Let’s drop a table dbo.Song.

DROP TABLE dbo.Song;

We could even drop a whole bunch of tables:

DROP TABLE dbo.Artist, dbo.Album, dbo.Playlist;

View

Let’s drop our view dbo.vLongSong.

DROP VIEW dbo.vLongSong;

Index

Let’s drop our index on dbo.Song.

DROP INDEX IX_NAME ON dbo.Song;

Stored Procedure

Let’s drop our stored procedure dbo.spSelectTableAndView.

DROP PROCEDURE dbo.spSelectTableAndView;