Create OR REPLACE Table

News

Abstract

CREATE TABLE enhanced with OR REPLACE option

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > Create OR REPLACE Table

Db2 for i is adding optional OR REPLACE capability to the CREATE TABLE SQL statement. By moving to a replacement table strategy, customers should have a much easier approach for managing change. Prior to this support, the user would need to construct the perfect ALTER TABLE statement or manually deal with removal and recreation of dependent objects. With CREATE OR REPLACE TABLE, Db2 for i will manage these complex tasks.

See the SQL Reference for details: CREATE TABLE statement

Note: This support was enabled after the Db2 for i PTF Group with the following PTF:
IBM i 7.2: 5770SS1 SI57123

[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]

Was this topic helpful?

Document Information

More support for:
IBM i

Software version:
All Versions

Operating system(s):
IBM i

Document number:
1164622

Modified date:
27 March 2025

UID

ibm11164622

IBM Support

Tips