Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to print all table from db

Status
Not open for further replies.
123Hai

123Hai

IS-IT--Management
Dec 30, 2002
6
0
0
IN
how to print all the table ( == describe table <table name>
of a data base ... is there any tool/ utility.....
 
Sort by date Sort by votes
Hi,
Presumably you don't mean 'How to print all data on a table' but do you mean that you would like to print a list of all the tables available? If so then you need to interrogate sysibm.systables
hth
Marc
 
Upvote 0 Downvote
AFAIK, there is no tool to do what you want to do ...

But you can combine the following commnads in a script and get the output

list tables for schema <schema-name>
describe table <tablename>

HTH

Sathyaram More DB2 questions answered at
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
54
gdg1976
gdg1976
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
87
tekpr00
tekpr00
P
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
114
prashant_0701
P
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
78
evr72
evr72
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
48
pratimsingha
pratimsingha

Part and Inventory Search

Sponsor

Back
Top