По поводу лога и прочего лучше всего
обратиться к документации. В частности, на счет лога пишут:
Цитата:
Compared to the DELETE statement, TRUNCATE TABLE has the following advantages:
- Less transaction log space is used. The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.
- ...
Цитата:
Сообщение от
DSPIC
Table properties:
1. Set Temporary = Yes
2. Synchronize
3. Set Temporary = No
4. Synchronize
Это то же, что drop table/sync Data Dictionary