SQL self-Increment 0 method

SQL identity Self-increment 0 method
1. Use the DBCC CONSOLE command:
    DBCC CHECKIDENT (table name, reseed,0)

2.truncate table can also clear the current identity value
   However, when there are constraints such as foreign keys, the table cannot be truncate

   You can disable the FOREIGN KEY constraint to truncate the table first:
   --Disable FOREIGN KEY constraints
   EXEC sp_msforeachtable ' ALTER TABLE? Nocheck constraint All '
   --Erase data
   TRUNCATE TABLE name
   --Enable FOREIGN KEY constraints
   EXEC sp_msforeachtable ' ALTER TABLE? Check constraint all '



TRUNCATE TABLE Schedule
TRUNCATE TABLE student Tables
TRUNCATE TABLE Selection Timetable