select name, type_desc from sys.all_sql_modules s inner join sys.all_objects o on s.object_id = o.object_id where definition like '%关键字%' order by type_desc, name;
select name, xtype from sysobjects o, syscomments s where o.id = s.id and text like '%agent%';
--查询所有包含某列名的对象 select name, object_id, type, type_desc from sys.objects where object_id in ( select object_id from sys.columns where name = 'serverid' );
如对本文有疑问, 点击进行留言回复!!
荐 灵活使用线程池 & 创建用户账号信息SQL数据库--社交APP-笔记整理
PostgreSQL select for update指定列(兼容oracle)
SQL语句中的WHERE、聚合函数(SUM、MIN、MAX、AVG、COUNT)、HAVING
sql server登录名、服务器角色、数据库用户、数据库角色、架构区别联系
网友评论