Is after Truncate Table constraints exist in SQL?

When we Truncate Table in SQL then all the all records from but table exist. I want to kno开发者_如何学JAVAw constraints,indexs remain exist or not ?

---

Truncate only removes the records in the table.

From MSDN (TRUNCATE TABLE):

TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause;

---

constraints,indexes remain. For more information check this

---

Your constraints and indexes will remain. Truncate also resets any auto-incremented IDs to zero.