Home » SQL & PL/SQL » SQL & PL/SQL » schema for all tables in a database
schema for all tables in a database [message #21470] Tue, 06 August 2002 03:56 Go to next message
meena
Messages: 36
Registered: December 2000
Member
How do I get the schema (indexes,columns,constraint) of all tables in a database. Desc command give only for a particular table.

Report message to a moderator

Re: schema for all tables in a database [message #21472 is a reply to message #21470] Tue, 06 August 2002 05:54 Go to previous message
CT-Guy
Messages: 2
Registered: August 2002
Junior Member
Hi Meena,
select * from all_tab_columns,
then you decide what you want and append where clause
to above sql.

Thanks
CT-Guy

Report message to a moderator

Previous Topic: What I thought was a simple insert statement!!!
Next Topic: Stroed Proc returning an array
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 06:30:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.