Truncate table query

• TomThomson

  SSC Guru

  Points: 104773

  More actions

  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
  

• Toreador

  SSChampion

  Points: 11375

  More actions

  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.