New answers tagged truncate
Seems to me its redundancy for future extensibility. There may not be any other use for TRUNCATE currently, but one could be added in the future. Or at least that would have been the mindset of the developers.
The syntax choice is likely for consistency, albeit redundant. TRUNCATE TABLE follows the same pattern as other DDL statements (CREATE, ALTER, DROP), where the object type immediately follows the action keyword. I should add TRUNCATE TABLE is part of the ANSI SQL Standard as of the 2008 version, although it was implemented in SQL Server long before then.
Top 50 recent answers are included