sreeharshavardhana

 Profile Answers by sreeharshavardhana 

• Apr 25th, 2006

 

As I found in MSDN,

TRUNCATE statement is used to delete table contents. Which faster than 'Delete from' statement. So, I should be a DML type of statement.

Hema

• May 15th, 2006

 

Trucate is DDL statement..which remove the data from the tables..But the structure will remain constant.

gorantla_rao

 Profile Answers by gorantla_rao 

• May 19th, 2006

 

Dear ,

         There is no doubt that TRUNCATE is a DDL Command.

          TRUNCATE deletes all the data from the table, but the structure remains as it is.

srinivas.

Amol

• May 24th, 2006

 

Truncate is a DDL statment.

Arun

• May 31st, 2006

 

Truncate                                                       DELETE

DDL Statement                                            DML statement

Cannot be rolled back                                   Can be rolled back

Where clause cannot be used                            Where can be used

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

 

other point it will not fire any trigers so it is fast .and it releases the storage space also. where delete command slower than truncate command fires triggers

Chiranjeevi Manne

• Mar 30th, 2007

 

TRUNCATE is a DDL statement which can't be rolled back as there won't be any redolog generated during the trun operation and it is the fastest way of dropping big tables avoiding tons and tons of redolog generation.