use [mydb]
go
--存储过程
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_type='PROCEDURE'
AND SPECIFIC_NAME LIKE '...%'
ORDER BY CREATED;
--自定义函数
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_type='FUNCTION'
AND SPECIFIC_NAME LIKE '...%'
ORDER BY CREATED;
--视图
select name
from sysobjects tab
where xtype = 'V'
and name like '...%'
--表
select name
from sysobjects tab
where xtype = 'U'
and name like '...%' or name like '...%'
转载于:https://www.cnblogs.com/leftfist/p/4257925.html