Home Forums Article Discussions Article Discussions by Author Discuss content posted by Vimal Lohani Truncate table query RE: Truncate table query

  • September 16, 2014 at 8:02 am

    #1745781

    GilaMonster (9/15/2014)

    TomThomson (9/15/2014)

    replication replicates DML statements, and DDL statements on replicated objects are either forbidden or have special forms and/or restrictions.

    It's got better. Alter table replicates now. Drop table isn;t allowed, the table has to be removed from the publication first and newly created tables aren't added (good reasons there at least). 1 out of three isn't bad.

    Well, some cases of ALTER TABLE work now. Possible not all, though - ALTER TABLE DROP CONSTRAINT would surely be a problem if the constraint being dropped was the primary key constraint. Or has replication changed so as not to rely on primary key?

    Tom