ADS build 7.9.97

Teradata

10.168.11.40
database - IVAN

Created 3 pairs of tables with Foreign Key options.
Teradata SQL Administrator scripted it correctly

ADS didnt script the tables correctly........

------------------------------------------------------------------------------------
DID NOT SPECIFY ANY OPTION -- DUPLICATE TABLE IS GENERATED
------------------------------------------------------------------------------------

CREATE TABLE PARENT_1 , NO FALLBACK , LOG (
    A    INTEGER NOT NULL,
    B    VARCHAR(12) NULL,
    CONSTRAINT P1_PK_1 PRIMARY KEY(A)
)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, REFERENCES, CREATE TRIGGER, DROP TRIGGER, DUMP, RESTORE, DROP TABLE ON AUG_BETA.PARENT_1 TO AUG_BETA WITH GRANT OPTION
GO
CREATE TABLE CHILD_1 , NO FALLBACK , LOG (
    A    INTEGER NOT NULL,
    B    INTEGER NOT NULL,
    C    VARCHAR(24) NULL,
    CONSTRAINT C1_PK_1 PRIMARY KEY(A,B)
)
GO
ALTER TABLE CHILD_1
    ADD CONSTRAINT FK_CHILD_1
    FOREIGN KEY(A)
    REFERENCES PARENT_1(A)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, REFERENCES, CREATE TRIGGER, DROP TRIGGER, DUMP, RESTORE, DROP TABLE ON AUG_BETA.CHILD_1 TO AUG_BETA WITH GRANT OPTION
GO

---------------------------
WITH CHECK OPTION
---------------------------

CREATE TABLE PARENT_2 , NO FALLBACK , LOG (
    A    INTEGER NOT NULL,
    B    VARCHAR(12) NULL,
    CONSTRAINT P1_PK_2 PRIMARY KEY(A)
)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, REFERENCES, CREATE TRIGGER, DROP TRIGGER, DUMP, RESTORE, DROP TABLE ON AUG_BETA.PARENT_2 TO AUG_BETA WITH GRANT OPTION
GO
CREATE TABLE CHILD_2 , NO FALLBACK , LOG (
    A    INTEGER NOT NULL,
    B    INTEGER NOT NULL,
    C    VARCHAR(24) NULL,
    CONSTRAINT C1_PK_2 PRIMARY KEY(A,B)
)
GO
ALTER TABLE CHILD_2
    ADD CONSTRAINT FK_CHILD_2
    FOREIGN KEY(A)
    REFERENCES WITH CHECK OPTION PARENT_2(A)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, REFERENCES, CREATE TRIGGER, DROP TRIGGER, DUMP, RESTORE, DROP TABLE ON AUG_BETA.CHILD_2 TO AUG_BETA WITH GRANT OPTION
GO

--------------------------------
WITH NO CHECK OPTION
--------------------------------


CREATE TABLE PARENT_3 , NO FALLBACK , LOG (
    A    INTEGER NOT NULL,
    B    VARCHAR(12) NULL,
    CONSTRAINT P1_PK_3 PRIMARY KEY(A)
)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, REFERENCES, CREATE TRIGGER, DROP TRIGGER, DUMP, RESTORE, DROP TABLE ON AUG_BETA.PARENT_3 TO AUG_BETA WITH GRANT OPTION
GO
CREATE TABLE CHILD_3 , NO FALLBACK , LOG (
    A    INTEGER NOT NULL,
    B    INTEGER NOT NULL,
    C    VARCHAR(24) NULL,
    CONSTRAINT C1_PK_3 PRIMARY KEY(A,B)
)
GO
ALTER TABLE CHILD_3
    ADD CONSTRAINT FK_CHILD_3
    FOREIGN KEY(A)
    REFERENCES WITH NO CHECK OPTION PARENT_3(A)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, REFERENCES, CREATE TRIGGER, DROP TRIGGER, DUMP, RESTORE, DROP TABLE ON AUG_BETA.CHILD_3 TO AUG_BETA WITH GRANT OPTION
GO