Delete all tables in the MSSQL database

--Remove all ConstraintsDECLAREC1cursor  for      Select 'ALTER TABLE ['+ object_name(parent_obj)+ '] Drop constraint ['+Name+']; '       fromsysobjectswhereXtype= 'F'  OpenC1Declare @c1 varchar(8000)  Fetch Next  fromC1 into @c1   while(@ @fetch_status=0)      begin          exec(@c1)          Fetch Next  fromC1 into @c1      End  CloseC1deallocateC1--Delete all tables in the databaseDeclare @tname varchar(8000)  Set @tname="'  Select @tname=@tname +Name+ ','  fromsysobjectswhereXtype='U'  Select @tname='drop table' +  Left(@tname,Len(@tname)-1)  exec(@tname)

Delete all tables in the MSSQL database