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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Descriptions

Status
Not open for further replies.
TheMus

TheMus

Technical User
Aug 23, 2000
28
US
How can I get the layout of a table to display? I've used DRAW but that only shows the fields. I'm looking for fields, data type and length.

Thanks in advance,

Rus
 
Sort by date Sort by votes
Check out the describe table syntax for your environment. In UNIX it looks like this:

$ db2 describe table MY.TABLE

This will give you the info you need.



Christopher Devenny
c_devenny@yahoo.com

 
Upvote 0 Downvote
Rus,
What platform are you on? If it's as/400, you should be able to do DSPFFD, this will give you all the info you need. I'm not sure if this command is valid for sql created tables...
--Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
124
evr72
evr72
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
141
fredericofonseca
fredericofonseca
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
102
pratimsingha
pratimsingha
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
71
usr1234
usr1234
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
92
SE2097
SE2097

Part and Inventory Search

Sponsor

Back
Top