Bulk Delete SQL Server data tables

Recently do data transfer, due to misoperation, in the system table master tables created n multiple tables is really impossible to delete

Find the following ways to share

---Specify the tables in the database to be deleted use mastergodeclare @sql varchar (8000), @TableName varchar () BEGIN  DECLARE cur cursor for  Select Name from sysobjects where xtype= ' P ' and crdate>= ' 2015-03-31 10:33:14.663 '  open cur  fetch next fro M cur to @TableName while  @ @fetch_status =0   begin    Set @sql = ' drop table ' [email protected]    --drop DEFAULT  PROCEDURE    exec (@sql)    fetch NEXT from cur to @TableName  end  Close cur  Deallocate Curend--select * from sysobjects where xtype= ' P ' ORDER by crdate

　　

Bulk Delete SQL Server data tables