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....
原创
2020-11-08 18:53:35 ·
455 阅读 ·
0 评论