Truncate - DotNet and DataBase

Saturday, 11 August 2018

Truncate



TRUNCATE Command is used to remove all records from a table and reset the table identity to initial value.
        
Syntax:
TRUNCATE TABLE <tbl_Name>
Example:
TRUNCATE TABLE EmployeeInfo


No comments:

Post a Comment

x

Get Updates On

Discussion updates

Straight Into Your INBOX!

Enter your email address to subscribe to this website and receive notifications of new posts by email.