All Downloads are FREE. Search and download functionalities are using the official Maven repository.

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

There is a newer version: 1.0.10
Show newest version
CREATE TABLE "LTHUSER".authors_data (authors_email VARCHAR(100) NOT NULL)
INSERT INTO "LTHUSER".authors_data SELECT DISTINCT email FROM "LTHUSER".authors WHERE email IS NOT NULL
ALTER TABLE "LTHUSER".authors_data ADD PRIMARY KEY (authors_email)
ALTER TABLE "LTHUSER".authors ADD CONSTRAINT FK_AUTHORS_AUTHORS_DATA FOREIGN KEY (email) REFERENCES "LTHUSER".authors_data (authors_email)




© 2015 - 2024 Weber Informatics LLC | Privacy Policy