• That's right but then

    what is the use of the set indentity ?

    if we set it to max no value in the table.

    so there no change in the table after or before this command.