Database Programming

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


User Avatar
Wiki User

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.