This blog is mostly a blog for me with hints to remember those little bits of code etc where ever I am. Please be aware of this when reading any of the posts as they are mainly reminders for me. When I get time I will try to flesh out those sections that are a little ambiguous.
Pages
▼
Wednesday, 10 May 2017
Create Table structure from another table in DB2 AS400
CREATE TABLE SCHEMA.NEW_TB AS (
SELECT *
FROM SCHEMA.OLD_TB
) WITH NO DATA
There is no way of copying the table structure and the data in the same way that
No comments:
Post a Comment
Note: only a member of this blog may post a comment.