Home » RDBMS Server » Server Administration » Describing all the tables in a database
Describing all the tables in a database [message #374494] Thu, 14 June 2001 17:36
Asim
Messages: 8
Registered: October 2000
Junior Member
Hi
I am trying to describe all the tables in a database.

We use desc or describe tablename; to describe a table, but what is the command to describe all the tables in a database (i don't need the system tables)

Once i log into sqlplus as a say ABC (SID or HostString) as a user then if i do a desc table name i get column name, data type and null not null etc but i i need that for all the tables in that ABC database

Thanks
-Asim

Report message to a moderator

Previous Topic: Re: Codds rule
Next Topic: Insert a column into exisitng table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 14:31:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.