vk-kirov (4/6/2010)
Paul White NZ (4/6/2010)
The primary purpose of TRUNCATE TABLE is to delete records - clearly a DML.Not so clear to Oracle guys 🙂
http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/statements_1001.htm – TRUNCATE is in the DDL list.
Groundhog day in here 😀
You posted that link and statement before!
If this were an Oracle site, I would tend to agree with you. As it is...:-P
All joking aside, let me clarify: The primary purpose of TRUNCATE TABLE (the T-SQL statement) is to delete rows, which is clearly a DML operation (in my view).
Oracle users can make their own arrangements :hehe:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi