Tutorial by Examples

Copy Table With Data

CREATE TABLE myschema.tableNew AS ( SELECT * FROM myschema.tableOld ) WITH DATA

db2 • Copy table with or without data

CREATE TABLE myschema.tableNew AS ( SELECT * FROM myschema.tableOld ) WITHOUT DATA

db2 • Copy table with or without data

CREATE TABLE myschema.tableNew AS ( SELECT * FROM myschema.tableOld WHERE column1 = 'myCriteria' ) WITH DATA

db2 • Copy table with or without data

Page 1 of 1

Get monthly updates about new articles, cheatsheets, and tricks.