The following steps are required to create a table in DB2 using AS and indicating the tablespace:
CREATE TABLE newtablename AS (SELECT * FROM existingtablename)
CREATE TABLE newtablename AS (SELECT * FROM existingtablename) TABLESPACE newtablespacename
Asked: 2023-05-08 04:54:14 +0000
Seen: 10 times
Last updated: May 08 '23