|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
 AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
August 26th, 2005, 08:49 AM
|
||||
|
||||
|
What's the DB2 command for MYSQL's Describe command?
I'm afraid this DB2 forum seem pretty much dead with not much activity for my question to be answered.
So, my question here is what's the DB2 equivalent for the MySQL's command for "DESCRIBE <table name>". Or does it work? I tried this "describe table <table name>" and get error message. Thanks... Last edited by fletchsod : August 26th, 2005 at 08:53 AM.
|
|
#2
August 27th, 2005, 05:11 PM
|
||||
|
||||
|
I stand corrected.
Last edited by Onslaught : October 9th, 2005 at 09:50 PM.
|
|
#3
October 7th, 2005, 11:41 PM
|
||||
|
||||
|
Code:
bash$ db2 ? describe
DESCRIBE {[OUTPUT] {select-statement | call-statement} |
{TABLE | INDEXES FOR TABLE} table-name [SHOW DETAIL]}
NOTE: From the operating system prompt, prefix commands with 'db2'.
Special characters MAY require an escape sequence (\), for example:
db2 \? change database
db2 ? change database xxx comment with \"text\"
bash$ db2 describe table myschema.mytable
|
|
#4
October 10th, 2005, 07:40 AM
|
||||
|
||||
|
Well, 2 months is a long time to wait. :-) I'm going to switch the database to MySQL at the end of the year. It's much nicer to use than DB2. (This machine is the last one to use DB2 for the Unix/Linux platform)
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > What's the DB2 command for MYSQL's Describe command? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
