Home » RDBMS Server » Server Administration » how to display table schema
how to display table schema [message #371947] Tue, 26 December 2000 09:15 Go to next message
FrankP
Messages: 1
Registered: December 2000
Junior Member
What is the command to display the schema of all the tables in a database.

Report message to a moderator

Re: how to display table schema [message #371961 is a reply to message #371947] Wed, 27 December 2000 09:43 Go to previous messageGo to next message
me
Messages: 66
Registered: August 2000
Member
if you have select privilege on dba views this one will show you the schema (owner) for all tables:

SELECT * FROM DBA_TABLES

if not this one will show you the schema (owner) for all tables that you have privileges to:

SELECT * FROM ALL_TABLES

Report message to a moderator

Re: how to display table schema [message #371962 is a reply to message #371947] Wed, 27 December 2000 09:48 Go to previous message
me
Messages: 66
Registered: August 2000
Member
if you have select privilege on dba views this one will show you the schema (owner) for all tables:

SELECT * FROM DBA_TABLES

if not this one will show you the schema (owner) for all tables that you have privileges to:

SELECT * FROM ALL_TABLES

Report message to a moderator

Previous Topic: Table Usage
Next Topic: Passing Variable in IN clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 18 11:06:37 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.