title: How to truncate a table which has replication activated on it
body: <p>I have a database that once a week, I need to kill and feel its data. The tables in this database are being replicated into another database.</p>
  <p>So whenever I try to truncate the tables, I get the error &quot;<em>Cannot truncate table 'Test' because it is published for replication or enabled for Change Data Capture.</em>&quot;</p>
  <p>My guess is I should drop this table/article from the publication/replication list, and then truncate and add it back onto the list of publication/replication, How can I do this using T-SQL?</p>
  <p>Questions Modified:</p>
  <p>In addition to what was asked above, I need to say, currently, I am deleting data from the tables, but because I have millions of records in some of my tables it's a very time-consuming process.</p>
  <p>What solution do you suggest for this situation?</p>