How to bulk clear all tables at once in MsSql?

Question

SQL Server

Hello!
How to bulk clear all tables at once in MsSql?
That to each table not to write truncate table.

Answer 1

Something like this:

declare @s nvarchar(max)  = ''
select @s  = @s  +
'truncate table '+TABLE_NAME+';'
  from INFORMATION_SCHEMA.TABLES 

exec (@s)

Answer 2

Stupid, but "armor-piercing" option:

DECLARE @execute_cmd varchar(max)= '';

-- выбрать один из трех вариантов по вкусу
--SELECT @execute_cmd = @execute_cmd+'begin try  truncate table ['+name+'] end try  begin catch end catch ' FROM sys.tables WHERE type_desc = 'USER_TABLE';

--SELECT @execute_cmd = @execute_cmd+'begin try  truncate table ['+TABLE_NAME+'] end try  begin catch end catch ' FROM information_schema.tables WHERE TABLE_TYPE = 'BASE TABLE';

--SELECT @execute_cmd = @execute_cmd+'begin try  truncate table ['+Name+'] end try  begin catch end catch ' FROM dbo.sysobjects WHERE xtype = 'U';

EXECUTE @execute_cmd;

and then repeatedly "hollow" the last line ....
because foreign key and just delete the table referenced by data from another table is not an option

Answer 3

DROP DATABASE dbname;
Joke :-D