db2Copy table with or without data
Introduction
Example of how to copy existing table structure with/without data
Syntax
- CREATE TABLE schemaName.table AS (SELECT columns FROM schemaName.table) WITH DATA
Copy table with or without data Related Examples
This modified text is an extract of the original Stack Overflow Documentation created by following contributors and released under CC BY-SA 3.0
This website is not affiliated with Stack Overflow