SQL Server Bulk Delete data tables

SET ANSI_NULLS on
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
--Author:<author,,name>
--Create Date: <create date,,>
--Description:<description,,>
-- =============================================
Alter PROCEDURE [dbo]. [Canceltable]

As
BEGIN
DECLARE @cul int
DECLARE @tablename varchar (50)
declare @dropSql nvarchar (100)
Select @cul =count (name) from sysobjects where name like ' stt% '
While @cul >0
Begin

Select @tablename =tb1.name from (select top 1 name from sysobjects where name like ' stt% ') as Tb1
Set @dropSql = ' drop table ' + ' [email protected];
EXECUTE sp_executesql @dropSql
Select @cul =count (name) from sysobjects where name like ' stt% '
End

END
GO

SQL Server Bulk Delete data tables