SQL Delete database all users table

--variable @tablename Save table name declare @tablename nvarchar ( -)--Save the user table to a temporary table #tablename select [name] into #tablename from Sysobjectswhere type='U';--When #tablename has data while(SelectCount1) from#tablename) >0begin--take the first one from the #tablenameSelectTop1@tablename =[name] from#tablename;--The table is deleted and the table name is a variable, so the dynamic sqlexec is used here ('drop table'+@tablename);--Delete this table name record from #tablename from#tablenamewhere[name]=@tablename; end

SQL Delete database all users table