ayi <t>Correct; you cannot truncate a table which has an FK constraint on it.<br/> <br/> Typically my process for this is:<br/> <br/> Drop the constraints<br/> <br/> Trunc the table<br/> <br/> Recreate the constraints.<br/> <br/> (All in a transaction, of course.)<br/> <br/> Of course, this only applies if the child has already been truncated. Otherwise I go a different route, dependent entirely on what my data looks like. (Too many variables to get into here.)<br/> <br/> The original poster determined WHY this is the case; see this answer for more details.</t>
