查看过程函数&表&列

 过程

oracle 查看：

select t.name,t.type from user_source t where t.TEXT like '%XXXX%';

sqlserver根据内容找名称：
select distinct object_name(id) from syscomments where id in
(select object_id from sys.objects where type ='P') and text like'%XXX%';


mysql 查看内容
SHOW CREATE PROCEDURE DB.P1;

SHOW CREATE FUNCTION DB.F1;

或者

--将XXX替换成你要查找的内容 
SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%XXX%' 
AND ROUTINE_TYPE='PROCEDURE' 

表

oracle

查看dba_tables,all_tables,user_tables

sqlserver:

SELECT a.name
FROM sysobjects a
WHERE a.type = 'u'

MySql:

show tables;

或者：

SELECT * FROM information_schema.`TABLES`

列：

oracle

    select t.table_name,
           f.comments     t_comments,
           t1.comments    c_comments,
           t1.column_name,
           t2.DATA_TYPE,
           t2.DATA_LENGTH,
           --t2.DATA_SCALE,
           t2.NULLABLE --,t2.*
      from user_tables t
     inner join user_tab_comments f
        on t.table_name = f.table_name
     inner join user_col_comments t1
        on t.TABLE_NAME = t1.table_name
     inner join user_tab_columns t2
        on t1.TABLE_NAME = t2.TABLE_NAME
       and t1.column_name = t2.COLUMN_NAME
       and t.TABLE_NAME = 'TABLE1'
     order by t.table_name, t2.COLUMN_ID