declare @tbl_name varchar(50)
while @@rowcount>0
begin
select @tbl_name=name from dbo.sysobjects where (left(name ,3)='ot_' and OBJECTPROPERTY(id, N'IsUserTable') = 1) or (left(name ,3)='os_' and OBJECTPROPERTY(id, N'IsUserTable') = 1) or (left(name ,3)='op_' and OBJECTPROPERTY(id, N'IsUserTable') = 1) order by name
exec('drop table ['+@tbl_name+']') --此处出错
end
while @@rowcount>0
begin
select @tbl_name=name from dbo.sysobjects where (left(name ,3)='ot_' and OBJECTPROPERTY(id, N'IsUserTable') = 1) or (left(name ,3)='os_' and OBJECTPROPERTY(id, N'IsUserTable') = 1) or (left(name ,3)='op_' and OBJECTPROPERTY(id, N'IsUserTable') = 1) order by name
exec('drop table ['+@tbl_name+']') --此处出错
end
解决方案 »
- 删除数据库中内容问题
- SQL Server2005怎样才能在 XP 系统中安装成功
- SQL2005备份的问题
- 大家一起帮我设计数据库--商品进销存数据库系统的设计
- [在线等]请教一个多表查询语句 关键字:INNER JOIN, SUM, GROUP BY
- 根据多个条件模糊查询
- 向表里插入一个数据,马上得到对应的ID号,怎么做?
- 数据恢复
- 在sql server上创建登陆的数目有限制吗?
- 谁能告诉我,从ORACLE站点下载的ORACLE和买的ORACLE有什么区别?
- 急!有关image类型数据存入与取出大小不同问题
- 看看这段Select语句是什么意识 left outer join dbo.tablename b on a.feild3=b.feild3 and a.feildn=
while @@rowcount>0
begin
select @tbl_name=[name] from dbo.sysobjects where
(left(name ,3)='ot_' or left(name ,3)='os_' or left(name ,3)='op_')
and OBJECTPROPERTY(id, N'IsUserTable') = 1 order by nameexec('drop table ' + @tbl_name )
end