Question : truncate restart identity - syntax error at or near "identity"
Answered by : emmanuel-mahuni
TRUNCATE TABLE table_name RESTART IDENTITY;
Source : https://stackoverflow.com/questions/13989243/sequence-does-not-reset-after-truncating-the-table | Last Update : Sun, 11 Apr 21