View previous topic :: View next topic
|
Author |
Message |
prabhucs01 Warnings : 1 New User
Joined: 07 Mar 2005 Posts: 43
|
|
|
|
what is the query that could be used to get the structure of DB2 table. |
|
Back to top |
|
|
priya
Moderator
Joined: 24 Jul 2003 Posts: 568 Location: Bangalore
|
|
|
|
Use SPUFI - DCLGEN or Try EXPLAIN Statement. |
|
Back to top |
|
|
T-REXDB2
New User
Joined: 28 Apr 2005 Posts: 11 Location: USA
|
|
Back to top |
|
|
T-REXDB2
New User
Joined: 28 Apr 2005 Posts: 11 Location: USA
|
|
|
|
Basic SQL SELECT structure:
SELECT *
FROM TABLENAME1 A, TABLENAME2 B, TABLENAME3 C
WHERE
[ PREDICATE LIST GOES HERE ]
ORDER BY [SORT ORDER COLUMN LIST GOES HERE]
That is the basic SQL structure. |
|
Back to top |
|
|
shymalasridevi
New User
Joined: 03 May 2005 Posts: 16
|
|
|
|
to retreive the structure we have aquery
DESC TABLE TABLENAME
OR
DESC TABLENAME
SO THAT IT WILL DISPLAY THE STRUCTURE |
|
Back to top |
|
|
gokuldass
New User
Joined: 18 Mar 2005 Posts: 48 Location: india
|
|
|
|
hai prabhucs01..
i think this query will help u..
select * from sysibm.syscolumns where tbcreator='yourid' and tbname='tbname';
i am using the same query.. try this and reply me.. |
|
Back to top |
|
|
|