tsql-purge.sql

while(exists(select 1 from INFORMATION_SCHEMA.VIEWS where TABLE_SCHEMA != 'sys'))
begin
  declare @sql nvarchar(2000)
  SELECT TOP 1 @sql=('DROP VIEW [' + TABLE_SCHEMA + '].[' + TABLE_NAME
  + ']')
   FROM INFORMATION_SCHEMA.VIEWS
  WHERE TABLE_SCHEMA != 'sys'
exec (@sql)
  PRINT @sql
end
while(exists(select 1 from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE = 'PROCEDURE' AND SPECIFIC_SCHEMA != 'sys'))
  begin
  declare @sql nvarchar(2000)
  SELECT TOP 1 @sql=('DROP PROCEDURE [' + SPECIFIC_SCHEMA + '].[' + SPECIFIC_NAME
  + ']')
  FROM INFORMATION_SCHEMA.ROUTINES
  WHERE ROUTINE_TYPE = 'PROCEDURE' AND SPECIFIC_SCHEMA != 'sys'
exec (@sql)
   PRINT @sql
end
while(exists(select 1 from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE = 'FUNCTION' AND SPECIFIC_SCHEMA != 'sys'))
  begin
  declare @sql nvarchar(2000)
  SELECT TOP 1 @sql=('DROP FUNCTION [' + SPECIFIC_SCHEMA + '].[' + SPECIFIC_NAME
  + ']')
  FROM INFORMATION_SCHEMA.ROUTINES
  WHERE ROUTINE_TYPE = 'FUNCTION' AND SPECIFIC_SCHEMA != 'sys'
exec (@sql)
  PRINT @sql
end

while(exists(select 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE='FOREIGN KEY'))
begin
    declare @sql1 nvarchar(2000)
    SELECT TOP 1 @sql1=('ALTER TABLE [' + TABLE_SCHEMA + '].[' + TABLE_NAME
    + '] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']')
    FROM information_schema.table_constraints
    WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'
    exec (@sql1)
    PRINT @sql1
end

GO
while(exists(select 1 from INFORMATION_SCHEMA.TABLES where TABLE_NAME != '__MigrationHistory' and TABLE_SCHEMA != 'sys'))
begin
 declare @sql nvarchar(2000)
 SELECT TOP 1 @sql=('DROP TABLE [' + TABLE_SCHEMA + '].[' + TABLE_NAME
 + ']')
 FROM INFORMATION_SCHEMA.TABLES
 WHERE TABLE_NAME != '__MigrationHistory'
     AND
 TABLE_SCHEMA != 'sys'
exec (@sql)
 PRINT @sql
end