Listar nombre de tablas SqlServer , Oracle

Listado de tablas con su Schema - SQL Server.

select b.name Esquema, a.name NombreTabla
from sys.tables a,sys.schemas b
where a.schema_id = b.schema_id
and type_desc='USER_TABLE'
order by b.name,a.name;

Listado de Store Procedure su Schema - SQL Server

select b.name Esquema, a.name NombreObjeto
from sys.procedures a, sys.schemas b
where a.schema_id = b.schema_id
order by b.name,a.name;

Listado de tanlas su Schema - Oracle

select owner Esquema,object_name NombreTabla 
from DBA_OBJECTS
where  object_type='TABLE'
order by owner,object_name;

Listado de Store Procedure su Schema - Oracle Server

SELECT owner Esquema,OBJECT_NAME NombreObjeto
FROM ALL_OBJECTS
WHERE  OBJECT_TYPE='PROCEDURE'
ORDER BY OBJECT_NAME;