DB2查看表定义
db2 describe table xxxxxx
db2 describe table xxxxxx show detail
db2 describe indexes for table xxxxxx show detail

Oracle查看表定义
desc xxxxxx

MSSQL/SYBASE查看表定义
sp_help xxxxxx

DB2查看存储过程的定义
select routineschema, routinename,specificname,text from syscat.routines where routinetype ='P' and specificname='HOUSEKEEP1' WITH UR;
Oracle查看存储过程的定义
SELECT * FROM USER_PROCEDURES WHERE OBJECT_TYPE='PROCEDURE';
SELECT * FROM DBA_PROCEDURES  WHERE OBJECT_TYPE='PROCEDURE';
SELECT * FROM ALL_PROCEDURES  WHERE OBJECT_TYPE='PROCEDURE';

SELECT * FROM USER_SOURCE WHERE NAME = 'STORED_PROC';
SELECT * FROM DBA_SOURCE WHERE NAME = 'STORED_PROC';
SELECT * FROM ALL_SOURCE WHERE NAME = 'STORED_PROC';

MSSQL
首先是查看有哪些存储过程，可以使用sp_MSForEachDB来查看所有数据库
EXEC sp_MSForEachDB 'SELECT name FROM sys.procedures'
select name from sys.objects where type='P';
得到存储过程的名字之后，用sp_helptext得到存储过程的具体内容
sp_helptext SPName