vk-kirov (4/7/2010)
Paul White NZ (4/6/2010)
You posted that link and statement before!Oops... did I?.. :blush:
I just want to say that your conclusion "if a command deletes rows, it's a DML" may be true in some cases (MSSQL, Sybase, ...) and false in other cases (Oracle, ...). (I hope I didn't post this statement before 🙂 )
Peter Trast (4/6/2010)
What is TRUNCATE if not a DML statement by that definition?Maybe because TRUNCATE manipulates metadata, not data? (It's my suggestion only)
Phil: Well, what if there is no tomorrow? There wasn't one today...... 😀
DOES truncate delete metadata??? (I am thinking no). I guess I was suggesting that the person who authored that webpage didn't know what he was talking about 🙂 Or it could just be me, it HAS been known to happen... lol
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems