Re: Get all table names in a database

select owner, object_name, object_type
from
all_objects
where
object_type in ('TABLE', 'SYNONYM', 'VIEW') order by
owner, object_name Received on Fri Jan 14 2000 - 20:29:35 CST