From: Lolling, Jan (Jan.Lollingt-systems.com)
Date: Fri Jul 04 2003 - 01:59:53 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

use DatabaseMetaData class from package java.sql or try this statement:
 
select * from user_columns
 
select * from user_tables
 
select * from user_indexes
 
you see its like oracle.
 
Jan
-----Ursprüngliche Nachricht-----
Von: Yusuf Gangat [mailto:yusuf.gangatpha.co.za]
Gesendet: Freitag, 4. Juli 2003 08:34
An: sapdb.generallistserv.sap.com
Betreff: (no subject)

Hi
 
Can anyone tell me how I could get a list of tables and columns for each table out of sap db using sql studio?
 
Thanks in advance
 
Yusuf Gangat
Programmer
Tel : 031-2675000
Fax : 031-2675169
yusuf.gangatpha.co.za <mailto:yusuf.gangatpha.co.za>
 
Disclaimer and confidentiality note

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Sweidan Trust is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt.
 
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.493 / Virus Database: 292 - Release Date: 6/25/2003

_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]