DDL: Drop Statements

TablePermalink

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;

ViewPermalink

Let’s drop our view dbo.vLongSong.

DROP VIEW dbo.vLongSong;

IndexPermalink

Let’s drop our index on dbo.Song.

DROP INDEX IX_NAME ON dbo.Song;

Stored ProcedurePermalink

Let’s drop our stored procedure dbo.spSelectTableAndView.

DROP PROCEDURE dbo.spSelectTableAndView;