摘要:
MS SQL支持 sysobject,因此可以用以下条件语句查询表对象select Name from sysobjects where xtype='U' and Name like 'dnt_%'以下是批量删除所有表名带有 dnt_的所有表declare @tname varchar(8000) set @tname='' select @tname=@tname + Name + ',' from sysobjects where xtype='U' and Name like 'dnt_%' 阅读全文