Database Programming

Will truncate and delete effect the structure of table in sql?

Answer

User Avatar
Wiki User
03/02/2007

No. Truncate and delete are mainly data oriented operations. They do not affect the structure of the table in any way. It also does not affect the other database objects like primary key,index,constraint etc created on that particular table.