This code blocks deletes all data from a table and resets identity field Once truncate gives error than you can use this code block
DELETE FROM Member DBCC CHECKIDENT (Member, RESEED, 1)
sql,delete,table,reseed,reset,identity,field,truncate
- 624 removing auto increment feature from column sql primary key This code block removed auto increment feature from a primary key auto incremented column.
- 755 sql update table with group by select inner sql This code block updates rows by inner sql with group by
- 765 sql change column name This code block changes a column name for a table.
Similar Codes
Report Bug
Reported Bugs
Comments
Delete Post
Are you sure you want to delete this post ?
Response
Reply
Report Code
Repeated Code
Not Working
Not Readable
Other
Comments