一些求数据库对象的SQL语句

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 '...%'