Home » RDBMS Server » Server Administration » Searching in all Tables
Searching in all Tables [message #374873] Mon, 09 July 2001 08:05 Go to next message
Kyle Haeussler
Messages: 1
Registered: July 2001
Junior Member
I recently acquired administrator rights for this website that i'm going to maintain. Is there a command that I can enter to get the names of all the tables, all the columns and the fields and how they are defined? Please let me know.

Report message to a moderator

Re: Searching in all Tables [message #374874 is a reply to message #374873] Mon, 09 July 2001 08:37 Go to previous messageGo to next message
cl
Messages: 10
Registered: April 2001
Junior Member
Get the names of all tables:
select table_name, owner from all_tables;
Or
select * from cat;

Get individual table column information:
desc table_name

EXAMPLE
SQL> desc dual
Name ....... Null? .......Type
---------- -------- ----------
DUMMY ............ VARCHAR2(1)

Report message to a moderator

Re: Searching in all Tables [message #374888 is a reply to message #374873] Mon, 09 July 2001 23:49 Go to previous message
Sudhakar Atmakuru
Messages: 58
Registered: May 2001
Member
You can get all the information of it from USER_TABLES and USER_TAB_COLUMNS tables;
The list gives you whole information of tables and their columns. Good luck.

Report message to a moderator

Previous Topic: Re: Help with an Oracle SQL Statement
Next Topic: Using AND & OR within DECODE statements
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 02:50:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.