mysql删除所有记录命令行_SQL..如何用命令删除数据库中所有的表?

要删除所有的用户表&＃xff1a;

declare &＃64;sql varchar(8000)

SELECT &＃64;sql&＃61;&＃39;drop table &＃39; &＃43; name FROM sysobjects

WHERE (type &＃61; &＃39;U&＃39;)

ORDER BY &＃39;drop table &＃39; &＃43; name

exec(&＃64;sql)

如果要删除所有用户表中的内容&＃xff0c;可以执行以下语句&＃xff1a;

declare &＃64;sql varchar(8000)

SELECT &＃64;sql&＃61;&＃39;truncate table &＃39; &＃43; name FROM sysobjects

WHERE (type &＃61; &＃39;U&＃39;)

ORDER BY &＃39;truncate table &＃39; &＃43; name

exec(&＃64;sql)

慎用&＃xff01;

如下也行&＃xff1a;

use 数据库名(是要删除表的所在的那个数据库的名称)

GO

declare &＃64;sql varchar(8000)

while (select count(*) from sysobjects where type&＃61;&＃39;U&＃39;)>0

begin SELECT &＃64;sql&＃61;&＃39;drop table &＃39; &＃43; name FROM sysobjects

WHERE (type &＃61; &＃39;U&＃39;)

ORDER BY &＃39;drop table &＃39; &＃43; name

exec(&＃64;sql)

end