Hi, Is it possible to recreate the SQL used to define an existing table?
I need to do this because there is no documentation available on a table defined long ago.
Can I use any QMF options or other tools? please suggest.
I am starting by analyzing the Db2 catalogs.
Recreate SQL used to define an existing table
Previous topic • Next topic • 3 posts
• Page 1 of 1
Recreate SQL used to define an existing table
by humble » Thu Apr 12, 2012 4:19 pm
- humble
- Posts: 9
- Joined: Thu Mar 01, 2012 5:01 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: Recreate SQL used to define an existing table
by Akatsukami » Thu Apr 12, 2012 4:47 pm
Start with the following query:
SELECT COLNO, NAME, COLTYPE, LENGTH, NULLS FROM SYSIBM.SYSCOLUMNS
WHERE TBNAME = 'table in question'
ORDER BY COLNO
WHERE TBNAME = 'table in question'
ORDER BY COLNO
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
-
Akatsukami - Global moderator
- Posts: 1058
- Joined: Sat Oct 16, 2010 2:31 am
- Location: Bloomington, IL
- Has thanked: 6 times
- Been thanked: 51 times
Previous topic • Next topic • 3 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Adding a new column to an existing primary Key.
by Shanthi_Palani » Thu Apr 13, 2017 12:59 pm - 1 Replies
- 3661 Views
- Last post by Shanthi_Palani
Thu Apr 20, 2017 11:27 am
- Adding a new column to an existing primary Key.
-
- Implement REFERENTIAL CONSTRAINTS on new or existing tables
by suresh48 » Thu Aug 18, 2011 12:43 pm - 1 Replies
- 1899 Views
- Last post by dick scherrer
Fri Aug 19, 2011 5:46 am
- Implement REFERENTIAL CONSTRAINTS on new or existing tables
-
- Converting multi table tablespaces into uni table tablespace
by suresh_48 » Mon Aug 15, 2011 7:06 pm - 2 Replies
- 2996 Views
- Last post by suresh48
Tue Aug 16, 2011 12:51 pm
- Converting multi table tablespaces into uni table tablespace
-
- FETCHING ROWS FROM ONE TABLE TO OTHER TABLE USING CURSORS
by avvarycobol » Wed Mar 23, 2011 8:05 pm - 7 Replies
- 4045 Views
- Last post by The Butcher
Sun Mar 27, 2011 8:36 pm
- FETCHING ROWS FROM ONE TABLE TO OTHER TABLE USING CURSORS
-
- First rows in Table A- process and write it to table
by raulravi » Thu Dec 13, 2012 4:48 pm - 6 Replies
- 2836 Views
- Last post by Akatsukami
Tue Dec 18, 2012 4:45 pm
- First rows in Table A- process and write it to table