db2Copy table with or without data


Introduction

Example of how to copy existing table structure with/without data

Syntax

  1. CREATE TABLE schemaName.table AS (SELECT columns FROM schemaName.table) WITH DATA