CODEWITHSUNDEEP
sql
Nakul Chaudhary
Nakul Chaudhary

Reputation: 26174

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 know constraints,indexs remain exist or not ?

Upvotes: 0

Views: 132

Answers (3)

RLT
RLT

Reputation: 438

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

Upvotes: 1

pavanred
pavanred

Reputation: 13823

constraints,indexes remain. For more information check this

Upvotes: 2

Oded
Oded

Reputation: 499132

Truncate only removes the records in the table.

From MSDN (TRUNCATE TABLE):

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

Upvotes: 2

Related Questions