• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• addColumn.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.change.expectedSql.db2-z.addColumn.sql Maven / Gradle / Ivy

CREATE TABLE "LTHUSER".add_column_test (id INTEGER NOT NULL, CONSTRAINT PK_ADD_COLUMN_TEST PRIMARY KEY (id))
ALTER TABLE "LTHUSER".add_column_test ADD varcharColumn VARCHAR(25)
ALTER TABLE "LTHUSER".add_column_test ADD intColumn INTEGER
ALTER TABLE "LTHUSER".add_column_test ADD dateColumn date
UPDATE "LTHUSER".add_column_test SET varcharColumn = 'INITIAL_VALUE'
UPDATE "LTHUSER".add_column_test SET intColumn = 5
UPDATE "LTHUSER".add_column_test SET dateColumn = DATE('2020-09-21')