liquibase.harness.change.expectedSql.oracle.19.addLookupTable.sql Maven / Gradle / Ivy
CREATE TABLE LBUSER.authors_data AS SELECT DISTINCT email AS authors_email FROM LBUSER.authors WHERE email IS NOT NULL
ALTER TABLE LBUSER.authors_data ADD PRIMARY KEY (authors_email)
ALTER TABLE LBUSER.authors ADD CONSTRAINT FK_AUTHORS_AUTHORS_DATA FOREIGN KEY (email) REFERENCES LBUSER.authors_data (authors_email)
© 2015 - 2024 Weber Informatics LLC | Privacy Policy