NuRoN Consulting, INC.

Blog > SQL Tools > Template Scripts > Schema > Drop objects belonging to Schema and schema

Template Script: Schema\Drop objects belonging to Schema and schema.sql

-- USE UTIL
USE <DBName>

DECLARE @SQL VARCHAR(MAX)
SELECT  @SQL = Util.dbo.StringConcat(dropscript, ';
')
FROM    (SELECT TOP 999999
                dropscript
         FROM   Metadata.ProcedureScripts
         WHERE  schemaname IN ('TransactionLoad', 'PropertyLoad', 'LoadCodeTables', 'LoadProperty', 'LoadBuilding', 'LoadFlagFiles', 'ExtractTemplate',
                               'BuildingLoad', 'LoadTransaction', 'LoadSubdivision')
         ORDER BY CASE WHEN TYPE = 'SCHEMA' THEN 1
                       ELSE 0
                  END) K

IF @SQL <> ''
    EXEC(@SQL)

Description for Template Script: Schema\Drop objects belonging to Schema and schema.sql

Todo