SQL Server Script to delete all FK in the DB and drop any table that starts with XXX

dropSlatwallDBTables.sql

DECLARE @sqlForeignKeys VARCHAR(MAX)

SELECT @sqlForeignKeys = ISNULL(@sqlForeignKeys,'') +
'ALTER TABLE dbo.[' + OBJECT_NAME(FK.parent_object_id) + '] DROP CONSTRAINT [' + FK.name + '];' + CHAR(10)
FROM SYS.FOREIGN_KEYS FK

//PRINT(@sqlForeignKeys)
EXEC(@sqlForeignKeys)



DECLARE @sqlForeignKeys VARCHAR(MAX)

SELECT @sqlForeignKeys = ISNULL(@sqlForeignKeys,'') +
'DROP TABLE dbo.[' + NAME + '] ;' + CHAR(10)
FROM sysobjects
where name like 'XXXX%'

//PRINT(@sqlForeignKeys)
EXEC(@sqlForeignKeys)