sqlserver 删除表 视图 函数 存储过程

use tax_ceshi
select 'DROP TABLE '+name from sysobjects where type = 'U'
union
select 'DROP VIEW '+name from sysobjects where type = 'V'
union
select 'DROP PROC '+name from sysobjects where type = 'P'
union
select 'drop function '+name from sysobjects where type = 'tf'
union
select 'drop function '+name from sysobjects where type = 'fn'

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/zhang-wenbin/p/10404739.html