Generated SQL commands to truncate all tables in the context database. Copy the SQL column and execute it. Remember, that TRUNCATE isn’t allowed for table referenced via a foreign key. SELECT [s].[name] [SchemaName], [t].[name] [TableName], ‘TRUNCATE TABLE [‘ + [s].[name] + ‘].[‘ + [t].[name] + ‘];’ [Sql] FROM [sys].[tables] [t]…

DECLARE @Stmt NVARCHAR(MAX) SET @Stmt = ” SELECT @Stmt = @Stmt + ‘DROP TABLE [‘ + s.name + ‘].[‘ + v.name + ‘];’ FROM sys.tables v INNER JOIN sys.schemas s ON s.schema_id = v.schema_id EXECUTE (@Stmt) GO SELECT * FROM sys.tables GO

DECLARE @Cmd NVARCHAR(MAX) SET @Cmd = CAST(( SELECT ‘SET IDENTITY_INSERT ‘ + QUOTENAME(OBJECT_SCHEMA_NAME([t].[object_id])) + ‘.’ + QUOTENAME([t].[name]) + ‘ OFF;’ + CHAR(10) FROM [sys].[columns] [c] INNER JOIN [sys].[tables] [t] ON [t].[object_id] = [c].[object_id] WHERE [c].[is_identity] = 1 ORDER BY 1 FOR XML PATH(”) ) AS NVARCHAR(MAX)); PRINT @Cmd EXEC [sys].[sp_executesql]…