sqlserver查询 表U、存储过程P、视图V、值函数FN、值函数TF 里关键词

--表U、存储过程P、视图V、值函数FN、值函数TF 
select a.name, a.[type], b.[definition], a.create_date, a.modify_date   
from sys.all_objects a 
        left join sys.sql_modules b on a.object_id = b.object_id
where a.is_ms_shipped=0  and a.[type] in ('P','V') 
        and b.[definition] like '%dbo.%'  
   
order by a.modify_date desc, a.[name] asc