Select from following answers:- Truncate

- delete
- drop
- Alter
- All Above
Truncate will not log individual row deletion.
Here is an example of how we can count the rows before and after truncate
SELECT COUNT(*) AS BeforeTruncateCount FROM MyTable.MyJob;
TRUNCATE TABLE MyTable.MyJob;
SELECT COUNT(*) AS AfterTruncateCount FROM MyTable.MyJob;
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator