SQL Server Deletes a table with a table name that contains the specified string

Delete the table containing the specified string

CREATE PROCEDURE Sys_deletetablebytablename (@bianliang varchar (100))
As
Begin
DECLARE @biao varchar (+), @sql varchar (1000)
Set @sql = '% ' [email protected]+ '% '
Declare c cursor for select name from sysobjects where type= ' u ' and name @sql
Set @sql = ' drop table '
Open C
Fetch C into @biao
While @ @fetch_status =0
Begin
Set @[email Protected][email protected]
EXEC (@sql)
Set @sql = ' drop table '
Fetch C into @biao
End
Close C
Deallocate C
Return
End

Execution method:
EXEC sys_deletetablebytablename ' stuinfo_backup_2015 '

SQL Server Deletes a table with a table name that contains the specified string