Created
June 15, 2009 11:40
-
-
Save kylewest/130059 to your computer and use it in GitHub Desktop.
Drop All Database Objects.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- THIS SCRIPT WILL DROP ALL DATABASE OBJECTS IN ANY MSSQL DATABASE | |
declare @n char(1) | |
set @n = char(10) | |
declare @stmt nvarchar(max) | |
-- procedures | |
select @stmt = isnull( @stmt + @n, '' ) + | |
'drop procedure [' + name + ']' | |
from sys.procedures | |
-- check constraints | |
select @stmt = isnull( @stmt + @n, '' ) + | |
'alter table [' + object_name( parent_object_id ) + '] drop constraint [' + name + ']' | |
from sys.check_constraints | |
-- functions | |
select @stmt = isnull( @stmt + @n, '' ) + | |
'drop function [' + name + ']' | |
from sys.objects | |
where type in ( 'FN', 'IF', 'TF' ) | |
-- views | |
select @stmt = isnull( @stmt + @n, '' ) + | |
'drop view [' + name + ']' | |
from sys.views | |
-- foreign keys | |
select @stmt = isnull( @stmt + @n, '' ) + | |
'alter table [' + object_name( parent_object_id ) + '] drop constraint [' + name + ']' | |
from sys.foreign_keys | |
-- tables | |
select @stmt = isnull( @stmt + @n, '' ) + | |
'drop table [' + name + ']' | |
from sys.tables | |
-- user defined types | |
select @stmt = isnull( @stmt + @n, '' ) + | |
'drop type [' + name + ']' | |
from sys.types | |
where is_user_defined = 1 | |
exec sp_executesql @stmt |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment