Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
List of table names and column names (Read 4976 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
List of table names and column names
16.04.07 at 20:53:36
 
List of table names and column names
 
Question:
I was wondering if there's a way to get a list of table names with all the column names associated with each table, all on one excel sheet?
 
Answer:
There is. From the SQL editor you can right click your schema or the tables collection within it and select to describe all tables.
 
You can also run the following SQL when you use Oracle:
Table lists:
select * from all_tables;
select * from user_tables;
 
Columns list:
select * from all_tab_column;
 
Hope this helps.
Back to top
 
« Last Edit: 16.04.07 at 20:57:30 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
sumosource
YaBB Newbies
*


I Love SQL*XL

Posts: 2
Re: List of table names and column names
Reply #1 - 17.04.07 at 22:04:01
 
Wow, this is great.  Thank you very much.  Hope all is well in Holland! Wink
Back to top
 
 
Email   IP Logged
Pages: 1