Post reply

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

  • September 30, 2014 at 8:57 am

    #1749187

    In Oracle, a Truncate cannot be rolled back (or couldn't last time I coded anything in Oracle). I suspect this is the origin of the myth that the same applies to SQLServer.

Viewing 2 posts - 46 through 46 (of 46 total)

You must be logged in to reply to this topic. Login to reply