drop table table1,table2,table3.... 删除整个库中的用户表 exec sp_MSforeachdb 'drop table ?'
刪除單張表 drop table 表名 刪除多張表 drop table 表名,表名2,表名3....删除整个库中的用户表 exec sp_MSforeachdb 'drop table ?'
再改一下就是删除多个表了.这是删除多个数据库的. DECLARE GID CURSOR READ_ONLY FOR SELECT convert(varchar(40),[name]) as spid FROM [master].[dbo].[sysdatabases] DECLARE @name varchar(40) OPEN GIDFETCH NEXT FROM GID INTO @name WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN exec ('drop database '+ @name ) END FETCH NEXT FROM GID INTO @name ENDCLOSE GID DEALLOCATE GID GO
drop table 表2
...
删除整个库中的用户表
exec sp_MSforeachdb 'drop table ?'
drop table 表名
刪除多張表
drop table 表名,表名2,表名3....删除整个库中的用户表
exec sp_MSforeachdb 'drop table ?'
DECLARE GID CURSOR
READ_ONLY
FOR SELECT convert(varchar(40),[name]) as spid FROM [master].[dbo].[sysdatabases]
DECLARE @name varchar(40)
OPEN GIDFETCH NEXT FROM GID INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
exec ('drop database '+ @name )
END
FETCH NEXT FROM GID INTO @name
ENDCLOSE GID
DEALLOCATE GID
GO
exec sp_MSforeachdb 'drop table ?' 有疑問呢,我也是第一次聽說...向 liangpei2008(我爱世界杯) 學習!