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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
13 January 2020
UID
ibm11164622